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

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Eci Souji" <eci(dot)souji(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: statistics buffer is full on heavily loaded 8.1.4 db.
Date: 2006-09-20 00:36:09
Message-ID: bf54be870609191736q22c060c3i93a4d139ddaaaa58@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)souji(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-09-20 01:01:49 Re: statistics buffer is full on heavily loaded 8.1.4 db.
Previous Message Eci Souji 2006-09-20 00:12:39 statistics buffer is full on heavily loaded 8.1.4 db.