| 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: | Whole Thread | Raw Message | 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... |