Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

statistics buffer is full



What does the message 'statistics buffer is full' mean? And if I saw lots of these in my logs what sort of bad things would happen? Presumably this is related to the planner statistics? Would I expect to have bad plans if this happens and how would I resolve it? This is what I found in the source, but I'm not really sure what's going on here:

Part of:

pgstat_recvbuffer(void)
<snip>
                /*
                 * As long as we have buffer space we add the socket to the read
                 * descriptor set.
                 */
                if (msg_have <= (int) (PGSTAT_RECVBUFFERSZ - sizeof(PgStat_Msg))
)
                {
                        FD_SET(pgStatSock, &rfds);
                        maxfd = pgStatSock;
                        overflow = false;
                }
                else
                {
                        if (!overflow)
                        {
                                ereport(LOG,
                                                (errmsg("statistics buffer is full")));
                                overflow = true;
                        }
                }


--
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group