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

From Tom Lane
Subject Re: statistics buffer is full
Date
Msg-id 8555.1076297006@sss.pgh.pa.us
Whole thread Raw
In response to statistics buffer is full  (Bjoern Metzdorf <bm@turtle-entertainment.de>)
List pgsql-admin
Bjoern Metzdorf <bm@turtle-entertainment.de> writes:
> one of our heavy loaded postgresql servers regularly gives
> LOG:  statistics buffer is full

You could try increasing PGSTAT_RECVBUFFERSZ in include/pgstat.h
(this will require recompiling src/backend/postmaster/pgstat.c
to take effect).  I'm not convinced it will help; it may just allow
the stats collector to fall further behind.  But if your problem
is load spikes it might help.

            regards, tom lane

pgsql-admin by date:

Previous
From: Bjoern Metzdorf
Date:
Subject: statistics buffer is full
Next
From: "scott.marlowe"
Date:
Subject: Re: hanging for 30sec when checkpointing