LOG: statistics buffer is full

From: Jérôme BENOIS <jerome(dot)benois(at)argia-engineering(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: LOG: statistics buffer is full
Date: 2006-06-22 07:24:05
Message-ID: 1150961045.4506.308.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

We use 7.4.6 version and now we have a bad performance on our
production server. We detected several strange messages in a log file :

LOG: statistics buffer is full
LOG: statistics buffer is full
LOG: statistics buffer is full

When i search on mailings list archive, i found a patch to increase the
buffer size in src/include/pgstat.h

-#define PGSTAT_RECVBUFFERSZ ((int) (1024 * sizeof(PgStat_Msg)))
+#define PGSTAT_RECVBUFFERSZ ((int) (16384 * sizeof(PgStat_Msg)))

And when i look the same file on the subversion trunk, the
"PGSTAT_RECVBUFFERSZ" constant is defined in a new file :
src/backend/postmaster/pgstat.c but with a same value.

Can you explain this statistics buffer problem ? And increase this
buffer size is a good resolution ?

Thanks for your help

Best Regards,
Jérôme BENOIS.
--
Share'nGo Team
http://www.sharengo.org

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2006-06-22 07:45:20 reg:lo_write
Previous Message Bruce Momjian 2006-06-22 01:30:03 Re: archive_log command...