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 1F6019FA5E7 for ; Fri, 23 Jun 2006 06:10:58 -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 74486-04 for ; Fri, 23 Jun 2006 06:10:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 71D899FA395 for ; Fri, 23 Jun 2006 06:10:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp5.orange.fr (smtp5.orange.fr [193.252.22.26]) by svr4.postgresql.org (Postfix) with ESMTP id BA58A5AF03B for ; Fri, 23 Jun 2006 09:10:50 +0000 (GMT) Received: from [192.168.1.10] (LSt-Amand-152-32-6-178.w82-127.abo.wanadoo.fr [82.127.21.178]) by mwinf0502.orange.fr (SMTP Server) with ESMTP id 2B5F41C001E8 for ; Fri, 23 Jun 2006 11:10:47 +0200 (CEST) X-ME-UUID: 20060623091047178.2B5F41C001E8@mwinf0502.orange.fr Subject: Re: LOG: statistics buffer is full From: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS To: pgsql-admin@postgresql.org In-Reply-To: References: <1150961045.4506.308.camel@localhost.localdomain> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-/io/zpVltZwxUtmKWbBj" Date: Fri, 23 Jun 2006 11:10:49 +0200 Message-Id: <1151053849.4506.498.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/212 X-Sequence-Number: 22174 --=-/io/zpVltZwxUtmKWbBj Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, Thanks Jim, i change stats_command_string=3Dfalse and i wait but it's works now :-) J=C3=A9r=C3=B4me. Le jeudi 22 juin 2006 =C3=A0 21:00 -0500, Jim Nasby a =C3=A9crit : > On Jun 22, 2006, at 2:24 AM, J=C3=A9r=C3=B4me BENOIS wrote: > > We use 7.4.6 version and now we have a bad performance on our >=20 > You should upgrade to the latest 7.4 version. >=20 > > production server. We detected several strange messages in a log =20 > > 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 =20 > > 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 ? >=20 > Do you have stats_command_string=3Don? If so, your best bet is probably =20 > to disable that, because it has a very high overhead (I've seen as =20 > much as over 50%). FWIW, Tom recently made changes in HEAD that =20 > essentially remove the overhead for using stats_command_string. > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 >=20 >=20 >=20 --=-/io/zpVltZwxUtmKWbBj 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) iD8DBQBEm7AZCDKlmlhpwnERAuvBAJ47zah57ENgdgyDhfGKAvY3yupquwCeJhME ZXlDkUYWWp/pH7ic2DKAri0= =BmxB -----END PGP SIGNATURE----- --=-/io/zpVltZwxUtmKWbBj--