Re: statistics buffer is full

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: statistics buffer is full
Date: 2004-02-09 03:23:26
Message-ID: 8555.1076297006@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de> writes:
> one of our heavy loaded postgresql servers regularly gives
> LOG: statistics buffer is full

You could try increasing PGSTAT_RECVBUFFERSZ in include/pgstat.h
(this will require recompiling src/backend/postmaster/pgstat.c
to take effect). I'm not convinced it will help; it may just allow
the stats collector to fall further behind. But if your problem
is load spikes it might help.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tuan Luu 2004-02-09 07:59:12 Foreign Key Question
Previous Message Bjoern Metzdorf 2004-02-08 22:39:41 statistics buffer is full