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 BC73B52A80 for ; Tue, 16 Aug 2005 23:27:19 -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 82224-09 for ; Wed, 17 Aug 2005 02:27:18 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0337552AB9 for ; Tue, 16 Aug 2005 23:27:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7H2RKtN010093; Tue, 16 Aug 2005 22:27:20 -0400 (EDT) To: John A Meinel Cc: Postgresql Performance Subject: Re: PG8 Tuning In-reply-to: <43027361.2070303@arbash-meinel.com> References: <1536.217.45.209.171.1123763001.squirrel@www.gradwell.com> <1123836428.19976.26.camel@amd64-laptop-spoe> <1123779524.6664.1.camel@toonses.gghcwest.com> <200508160912.32263.josh@agliodbs.com> <20050816162531.GB32695@alvh.no-ip.org> <43021567.1000101@arbash-meinel.com> <7516.1124232599@sss.pgh.pa.us> <43027361.2070303@arbash-meinel.com> Comments: In-reply-to John A Meinel message dated "Tue, 16 Aug 2005 18:14:41 -0500" Date: Tue, 16 Aug 2005 22:27:20 -0400 Message-ID: <10092.1124245640@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/193 X-Sequence-Number: 13940 John A Meinel writes: > So pg_xlog is really only needed for a dirty shutdown. So what about the > idea of having pg_xlog on a ramdisk that is syncronized periodically to > a real disk. Well, if "periodically" means "at every transaction commit", that's pretty much what we do now. regards, tom lane