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 DCAA6D1B45B for ; Sun, 8 Feb 2004 22:41:13 +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 71483-01 for ; Sun, 8 Feb 2004 18:41:10 -0400 (AST) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id 3E2FBD1D9E6 for ; Sun, 8 Feb 2004 18:41:07 -0400 (AST) Received: from ip97.85.1311c-cud12k-02.ish.de ([62.143.85.97] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1Apxbh-0004PY-00 for ; Sun, 08 Feb 2004 23:40:53 +0100 Received: from pd9e219de.dip.t-dialin.net ([217.226.25.222] helo=turtle-entertainment.de) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1Apxbh-0006re-00 for ; Sun, 08 Feb 2004 23:40:53 +0100 Message-ID: <4026BAAD.4060708@turtle-entertainment.de> Date: Sun, 08 Feb 2004 23:39:41 +0100 From: Bjoern Metzdorf User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: statistics buffer is full Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/116 X-Sequence-Number: 12290 Hi, one of our heavy loaded postgresql servers regularly gives LOG: statistics buffer is full Sometimes those messages come when there is a load peak on the server, so it comes to my mind that it may be possible to improve performance by tweaking postgresql.conf to get rid of that full buffers. We run 7.4.1 on Linux 2.4 (Dual Xeon 2,4, 3 GB RAM). pg_autovacuum is running. postgresql.conf (tweaked parameters only): shared_buffers = 20000 sort_mem = 16384 fsync = false wal_buffers = 256 checkpoint_segments = 6 log_timestamp = true stats_start_collector = true stats_row_level = true Any hints? Regards, Bjoern