X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DDF745E46C9 for ; Sun, 8 Aug 2004 02:40:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47245-02 for ; Sun, 8 Aug 2004 05:40:25 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CDE825E3E30 for ; Sun, 8 Aug 2004 02:40:25 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i785eOiG047874 for ; Sun, 8 Aug 2004 05:40:24 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i785EWUW042041 for pgsql-performance@postgresql.org; Sun, 8 Aug 2004 05:14:32 GMT From: Martin Foster User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-ca, en-gb, en-us, en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Performance Bottleneck References: <410FDC53.5080509@bigfoot.com> <4110FFF6.1030001@bigfoot.com> <41140D17.7070101@ethereal-realms.org> <24609.1091836821@sss.pgh.pa.us> <4114AABD.7050505@bigfoot.com> <4114B3CE.2020504@familyhealth.com.au> In-Reply-To: <4114B3CE.2020504@familyhealth.com.au> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 25 Message-ID: Date: Sun, 08 Aug 2004 05:14:32 GMT To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/99 X-Sequence-Number: 7735 Christopher Kings-Lynne wrote: >>> This value of wal_buffers is simply ridiculous. >> >> >> >> Instead I think is ridiculous a wal_buffers = 8 ( 64KB ) by default. > > > There is no point making WAL buffers higher than 8. I have done much > testing of this and it makes not the slightest difference to performance > that I could measure. > > Chris > No point? I had it at 64 if memory serves and logs were warning me that raising this value would be desired because of excessive IO brought upon from the logs being filled far too often. It would seem to me that 8 is a bit low in at least a few circumstances. Martin Foster Creator/Designer Ethereal Realms martin@ethereal-realms.org