X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5271D475A45; Thu, 13 Feb 2003 22:10:53 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 056E84759AF; Thu, 13 Feb 2003 22:10:52 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1E3Aa5u003580; Thu, 13 Feb 2003 22:10:56 -0500 (EST) To: "Christopher Kings-Lynne" Cc: "Hackers" , pgsql-performance@postgresql.org Subject: Re: [HACKERS] More benchmarking of wal_buffers In-reply-to: References: Comments: In-reply-to "Christopher Kings-Lynne" message dated "Fri, 14 Feb 2003 11:05:04 +0800" Date: Thu, 13 Feb 2003 22:10:35 -0500 Message-ID: <3579.1045192235@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/66 X-Sequence-Number: 1122 "Christopher Kings-Lynne" writes: > Here's a question then - what is the _drawback_ to having 1024 wal_buffers > as opposed to 8? Waste of RAM? You'd be better off leaving that 8 meg available for use as general-purpose buffers ... regards, tom lane