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

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)