Thread: what does it mean
Hi, I've upgraded my production system to 741 yesterday, and just discovered this log message: statistic buffer is full. What does it mean? filing up too fast, no more stats, need to grow? What should I do? Also, Many thanks for this great versionn of PostgreSQL, keep going... Revgards -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
ohp@pyrenet.fr writes:
> I've upgraded my production system to 741 yesterday, and just discovered
> this log message: statistic buffer is full.
If you see this a lot, it might be worth increasing PGSTAT_RECVBUFFERSZ.
regards, tom lane
Thanks for replying Tom, How much is a lot? it occured ~30 times since 23pm (it's 17:48 pm now) On Mon, 26 Jan 2004, Tom Lane wrote: > Date: Mon, 26 Jan 2004 09:48:03 -0500 > From: Tom Lane <tgl@sss.pgh.pa.us> > To: ohp@pyrenet.fr > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: [HACKERS] what does it mean > > ohp@pyrenet.fr writes: > > I've upgraded my production system to 741 yesterday, and just discovered > > this log message: statistic buffer is full. > > If you see this a lot, it might be worth increasing PGSTAT_RECVBUFFERSZ. > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
ohp@pyrenet.fr writes:
>>> I've upgraded my production system to 741 yesterday, and just discovered
>>> this log message: statistic buffer is full.
>>
>> If you see this a lot, it might be worth increasing PGSTAT_RECVBUFFERSZ.
>
> How much is a lot? it occured ~30 times since 23pm (it's 17:48 pm now)
Hm. I wonder whether something is interfering with the stats collection
code on your system? I can't recall anyone else reporting seeing this
log message, so I'm not convinced that PGSTAT_RECVBUFFERSZ is too small.
What platform are you using, again?
regards, tom lane
--On Monday, January 26, 2004 12:11:19 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote: > ohp@pyrenet.fr writes: >>>> I've upgraded my production system to 741 yesterday, and just >>>> discovered this log message: statistic buffer is full. >>> >>> If you see this a lot, it might be worth increasing PGSTAT_RECVBUFFERSZ. >> >> How much is a lot? it occured ~30 times since 23pm (it's 17:48 pm now) > > Hm. I wonder whether something is interfering with the stats collection > code on your system? I can't recall anyone else reporting seeing this > log message, so I'm not convinced that PGSTAT_RECVBUFFERSZ is too small. > > What platform are you using, again? UnixWare 7.1.3 LER > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
On Mon, 26 Jan 2004, Tom Lane wrote: > Date: Mon, 26 Jan 2004 12:11:19 -0500 > From: Tom Lane <tgl@sss.pgh.pa.us> > To: ohp@pyrenet.fr > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>, > Jan Wieck <JanWieck@Yahoo.com> > Subject: Re: [HACKERS] what does it mean > > ohp@pyrenet.fr writes: > >>> I've upgraded my production system to 741 yesterday, and just discovered > >>> this log message: statistic buffer is full. > >> > >> If you see this a lot, it might be worth increasing PGSTAT_RECVBUFFERSZ. > > > > How much is a lot? it occured ~30 times since 23pm (it's 17:48 pm now) > > Hm. I wonder whether something is interfering with the stats collection > code on your system? I can't recall anyone else reporting seeing this > log message, so I'm not convinced that PGSTAT_RECVBUFFERSZ is too small. > > What platform are you using, again? UnixWare 7.1.3 UP3 Just noticed now, it also happend on 7.3.5 (the log message was different...) Do you need something to analyze it? > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)