Re: statistics buffer is full

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