Re: statistics buffer is full

[Jeff Frost <jeff(at)frostconsultingllc(dot)com>]

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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954