pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  2007-04-23 14:21 ` Re: CESTLOG: statistics buffer is full Tom Lane <tgl@sss.pgh.pa.us>
  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 10:56 CESTLOG:  statistics buffer is full Achakzai, Omar <omar.achakzai@logicacmg.com>
@ 2007-04-23 14:21 ` Tom Lane <tgl@sss.pgh.pa.us>
  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