Postgres Pro
Downloads
Home   >   mailing lists

Thread: CESTLOG: statistics buffer is full

CESTLOG: statistics buffer is full

From
"Achakzai, Omar"
Date:

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.

Re: CESTLOG: statistics buffer is full

From
Tom Lane
Date:
"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