X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CEF13D1B8C0 for ; Fri, 12 Dec 2003 22:37:18 +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 06594-03 for ; Fri, 12 Dec 2003 18:36:50 -0400 (AST) Received: from mta1.sucs.soton.ac.uk (mta1.sucs.soton.ac.uk [152.78.128.140]) by svr1.postgresql.org (Postfix) with ESMTP id C2508D1B4C5 for ; Fri, 12 Dec 2003 18:36:46 -0400 (AST) Received: from russell (cpc1-glfd2-4-0-cust205.glfd.cable.ntl.com [81.99.187.205]) (authenticated bits=0) by mta1.sucs.soton.ac.uk (8.12.10/8.12.10) with ESMTP id hBCMaP3A022304; Fri, 12 Dec 2003 22:36:26 GMT From: "Russell Garrett" To: "William Yu" , Subject: Re: Update on putting WAL on ramdisk/ Date: Fri, 12 Dec 2003 22:36:26 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-reply-to: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-ISS-MailScanner: Believed to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/208 X-Sequence-Number: 5068 > WAL on single drive: 7.990 rec/s > WAL on 2nd IDE drive: 8.329 rec/s > WAL on tmpfs: 13.172 rec/s > > A huge jump in performance but a bit scary having a WAL that can > disappear at any time. I'm gonna workup a rsync script and do some > power-off experiments to see how badly it gets mangled. Surely this is just equivalent to disabling fsync? If you put a WAL on a volatile file system, there's not a whole lot of point in having one at all. -------------------------------------------------------------------- Russ Garrett russ@last.fm http://last.fm