[GENERAL] statistics buffer is full on heavily loaded 8.1.4 db.

We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg 8.1.4 server. Upon startup we see around 15-20 statistics buffer is full messages and they repeat at random times throughout the day. During peak times the box sometimes seems to grind to a halt. Any thoughts? - E

Re: [GENERAL] statistics buffer is full on heavily loaded 8.1.4 db.

Do you have stats_command_string=onin postgresql.conf as that might cause this error.If it is truned on please turn it off and then try starting your server.Thanks,-- Shoaib MirEnterpriseDB ( www.enterprisedb.com)On 9/20/06, Eci Souji [EMAIL PROTECTED] wrote: We have a 4x 2.4ghz Opteron box w/ 8

Re: [GENERAL] statistics buffer is full on heavily loaded 8.1.4 db.

Eci Souji wrote: We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg 8.1.4 server. Upon startup we see around 15-20 statistics buffer is full messages and they repeat at random times throughout the day. During peak times the box sometimes seems to grind to a halt. Any

Re: [GENERAL] statistics buffer is full on heavily loaded 8.1.4 db.

Oops, knew I forgot something. Here are the settings from our postgresql.conf I beilive it's set to allow autovac to work and nothing else. # - Query/Index Statistics Collector - stats_start_collector = on stats_command_string = off stats_block_level = off stats_row_level = on