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
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... |