Re: statistics buffer is full - Mailing list pgsql-admin

From Jeff Frost
Subject Re: statistics buffer is full
Date
Msg-id Pine.LNX.4.64.0611082145020.23695@discord.home.frostconsultingllc.com
Whole thread Raw
In response to Re: statistics buffer is full  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: statistics buffer is full  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: statistics buffer is full  ("Jim C. Nasby" <jim@nasby.net>)
Re: statistics buffer is full  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
On Wed, 8 Nov 2006, Joshua D. Drake wrote:

>> hah!  Does that mean it's just the buffering for pg_stat_activity and not for
>> planner statistics?  That doesn't make me feel too bad in this case.
>
> Yeah it is nothing to worry about, however turning it off is certainly a
> performance benefit.
>

So, then the next question: is that error because the command string was too
long or because there were too many command strings in the buffer at once
(i.e. it got backed up a bit and filled)?

It would be a drag to be without pg_stat_activity on this system.  The
performance detriment is lessened in 8.2, correct?

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: statistics buffer is full
Next
From: "Joshua D. Drake"
Date:
Subject: Re: statistics buffer is full