X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 13943474E4F; Thu, 13 Feb 2003 23:23:44 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 50F58474E42; Thu, 13 Feb 2003 23:23:43 -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 h1E4Ni5u004004; Thu, 13 Feb 2003 23:23:44 -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:16:04 +0800" Date: Thu, 13 Feb 2003 23:23:44 -0500 Message-ID: <4003.1045196624@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/73 X-Sequence-Number: 1129 "Christopher Kings-Lynne" writes: > What I mean is say you have an enterprise server doing heaps of transactions > with lots of work. If you have scads of RAM, could you just shove up > wal_buffers really high and assume it will improve performance? There is no such thing as infinite RAM (or if there is, you paid *way* too much for your database server). My feeling is that it's a bad idea to put more than you absolutely have to into single-use buffers. Multi-purpose buffers are usually a better use of RAM. regards, tom lane