pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Qingqing Zhou <zhouqq@cs.toronto.edu>
To: pgsql-performance@postgresql.org
Subject: Re: statistics buffer is full
Date: Sun, 2 Apr 2006 22:33:05 +0800
Message-ID: <e0onb0$2p1h$1@news.hub.org> (raw)
References: <442A7C08.3020206@i-logic.hu>


""Gábriel Ákos"" <akos.gabriel@i-logic.hu> wrote
>
> I've got this message while heavily inserting into a database. What should 
> I tune and how? It is postgresql 8.1.3.
>
> 2006-03-29 14:16:57.513 CEST:LOG:  statistics buffer is full
>

Since your server is in a heavy load, so the common trick is to increase 
PGSTAT_RECVBUFFERSZ in include/pgstat.h and recompile your server.

Regards,
Qingqing 

view thread (2+ messages)

Message-ID: <e0onb0$2p1h$1@news.hub.org>
Permalink:  ../e0onb0$2p1h$1@news.hub.org/
Also on:    postgresql.org/message-id/e0onb0$2p1h$1@news.hub.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: zhouqq@cs.toronto.edu
  Subject: Re: statistics buffer is full
  In-Reply-To: <e0onb0$2p1h$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox