Re: 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
> thoughts?

Do you have stats_command_string on?

Joshua D. Drake


>
> - E
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/