pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
CESTLOG: statistics buffer is full 2+ messages / 2 participants [nested] [flat]
* CESTLOG: statistics buffer is full @ 2007-04-23 10:56 Achakzai, Omar <omar.achakzai@logicacmg.com> 0 siblings, 1 reply; 2+ messages in thread From: Achakzai, Omar @ 2007-04-23 10:56 UTC (permalink / raw) To: pgsql-admin Hi, We use PostgreSQL version 8.1.4. Autovacuum is on. The message "CESTLOG: statistics buffer is full" appears repeatedly in the logfile of the database. I searched on the Internet, but couldn't find much about this message. What kind of statistics is being kept in the statistics buffer? Why does this buffer usually fill up? too small? Is the work load on the database too high? How can we solve the problem? Kind regards, Omar. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CESTLOG: statistics buffer is full @ 2007-04-23 14:21 Tom Lane <tgl@sss.pgh.pa.us> parent: Achakzai, Omar <omar.achakzai@logicacmg.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-04-23 14:21 UTC (permalink / raw) To: Achakzai, Omar <omar.achakzai@logicacmg.com>; +Cc: pgsql-admin "Achakzai, Omar" <omar.achakzai@logicacmg.com> writes: > The message "CESTLOG: statistics buffer is full" appears repeatedly in the= > logfile of the database. You might want to put a space at the end of your log_line_prefix. > How can we solve the problem? I think the only real solution is to update to 8.2, which handles stats collector traffic differently. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-04-23 14:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-04-23 10:56 CESTLOG: statistics buffer is full Achakzai, Omar <omar.achakzai@logicacmg.com> 2007-04-23 14:21 ` Re: CESTLOG: statistics buffer is full Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox