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)

Mon, 26 Jan 2004 14:25:58 +0100 (MET)
ohp@pyrenet.fr
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

Mon, 26 Jan 2004 09:48:03 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: what does it mean 
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)

Mon, 26 Jan 2004 17:48:34 +0100 (MET)
ohp@pyrenet.fr
Re: 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?

			regards, tom lane

Mon, 26 Jan 2004 12:11:19 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: what does it mean 
--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
Mon, 26 Jan 2004 11:24:54 -0600
Larry Rosenman <ler@lerctr.org>
Re: what does it mean 
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)

Mon, 26 Jan 2004 18:52:25 +0100 (MET)
ohp@pyrenet.fr
Re: what does it mean 