| From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: statistics buffer is full |
| Date: | 2006-11-09 03:29:29 |
| Message-ID: | Pine.LNX.4.64.0611081927530.23695@discord.home.frostconsultingllc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 8 Nov 2006, Joshua D. Drake wrote:
> On Wed, 2006-11-08 at 18:46 -0800, Jeff Frost wrote:
>> What does the message 'statistics buffer is full' mean? And if I saw lots of
>> these in my logs what sort of bad things would happen? Presumably this is
>> related to the planner statistics? Would I expect to have bad plans if this
>> happens and how would I resolve it? This is what I found in the source, but
>> I'm not really sure what's going on here:
>
> Usually it means that you have stats_command_string turned on :)
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.
--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-11-09 03:43:39 | Re: statistics buffer is full |
| Previous Message | Joshua D. Drake | 2006-11-09 03:27:49 | Re: statistics buffer is full |