X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AE6099FA430 for ; Thu, 22 Jun 2006 04:49:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36133-01-2 for ; Thu, 22 Jun 2006 04:49:25 -0300 (ADT) X-Greylist: delayed 00:25:15.68486 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 529339FA6B4 for ; Thu, 22 Jun 2006 04:49:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp8.orange.fr (smtp8.orange.fr [193.252.22.23]) by svr4.postgresql.org (Postfix) with ESMTP id C077E5AF043 for ; Thu, 22 Jun 2006 07:24:05 +0000 (GMT) Received: from [192.168.1.10] (LSt-Amand-152-32-6-178.w82-127.abo.wanadoo.fr [82.127.21.178]) by mwinf0806.orange.fr (SMTP Server) with ESMTP id 7C4DB1C0009E; Thu, 22 Jun 2006 09:24:02 +0200 (CEST) X-ME-UUID: 20060622072402509.7C4DB1C0009E@mwinf0806.orange.fr Subject: LOG: statistics buffer is full From: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS To: pgsql-admin@postgresql.org Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-XKpmfRGgFYVy9QrUp/9Q" Date: Thu, 22 Jun 2006 09:24:05 +0200 Message-Id: <1150961045.4506.308.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/183 X-Sequence-Number: 22145 --=-XKpmfRGgFYVy9QrUp/9Q Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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=20 -#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=C3=A9r=C3=B4me BENOIS. -- Share'nGo Team http://www.sharengo.org --=-XKpmfRGgFYVy9QrUp/9Q Content-Type: application/pgp-signature; name=signature.asc Content-Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?= -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) iD8DBQBEmkWVCDKlmlhpwnERAixjAJ9yvALjMg/0b8vLP4SDMeS+to4MhQCfVeLN EyYXzFKNTuPvBuvuo0mE4Rw= =wlst -----END PGP SIGNATURE----- --=-XKpmfRGgFYVy9QrUp/9Q--