X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D88F2D1CCAF for ; Mon, 9 Feb 2004 03:23:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40065-04 for ; Sun, 8 Feb 2004 23:23:27 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B41EDD1B837 for ; Sun, 8 Feb 2004 23:23:22 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i193NRGr008556; Sun, 8 Feb 2004 22:23:27 -0500 (EST) To: Bjoern Metzdorf Cc: pgsql-admin@postgresql.org Subject: Re: statistics buffer is full In-reply-to: <4026BAAD.4060708@turtle-entertainment.de> References: <4026BAAD.4060708@turtle-entertainment.de> Comments: In-reply-to Bjoern Metzdorf message dated "Sun, 08 Feb 2004 23:39:41 +0100" Date: Sun, 08 Feb 2004 22:23:26 -0500 Message-ID: <8555.1076297006@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/117 X-Sequence-Number: 12291 Bjoern Metzdorf 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