Postgres Pro
Downloads
Home   >   mailing lists

Re: statistics buffer is full on heavily loaded 8.1.4 db. - Mailing list pgsql-general

From Shoaib Mir
Subject Re: statistics buffer is full on heavily loaded 8.1.4 db.
Date
Msg-id bf54be870609191736q22c060c3i93a4d139ddaaaa58@mail.gmail.com
Whole thread Raw
In response to statistics buffer is full on heavily loaded 8.1.4 db.  (Eci Souji <eci.souji@gmail.com>)
List pgsql-general
Tree view
Do you have

stats_command_string=on

in 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 Mir
EnterpriseDB ( www.enterprisedb.com)

On 9/20/06, Eci Souji <eci.souji@gmail.com> 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 thoughts?

- E



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq




pgsql-general by date:

Previous
From: Eci Souji
Date:
Subject: statistics buffer is full on heavily loaded 8.1.4 db.
Next
From: "Joshua D. Drake"
Date:
Subject: Re: statistics buffer is full on heavily loaded 8.1.4 db.