Re: 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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

ohp(at)pyrenet(dot)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(at)sss(dot)pgh(dot)pa(dot)us>
> To: ohp(at)pyrenet(dot)fr
> Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: [HACKERS] what does it mean
>
> ohp(at)pyrenet(dot)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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

ohp(at)pyrenet(dot)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(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> ohp(at)pyrenet(dot)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(at)postgresql(dot)org
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)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(at)sss(dot)pgh(dot)pa(dot)us>
> To: ohp(at)pyrenet(dot)fr
> Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>,
> Jan Wieck <JanWieck(at)Yahoo(dot)com>
> Subject: Re: [HACKERS] what does it mean
>
> ohp(at)pyrenet(dot)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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)