X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 45AE0329EAD for ; Wed, 15 Sep 2004 19:47:49 +0100 (BST) 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 55668-02 for ; Wed, 15 Sep 2004 18:47:44 +0000 (GMT) Received: from mr2.surnet.cl (av2.surnet.cl [216.155.73.169]) by svr1.postgresql.org (Postfix) with ESMTP id AE949329ED3 for ; Wed, 15 Sep 2004 19:47:45 +0100 (BST) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.024) id 413E2E5500141569; Wed, 15 Sep 2004 14:44:52 -0400 Received: from av2.surnet.cl ([216.155.73.169]) by smtp2.surnet.cl (MailMonitor for SMTP v1.2.2 ) ; Wed, 15 Sep 2004 14:44:52 -0400 (CLT) Received: from cluster.surnet.cl (216.155.73.165) by smtp2.surnet.cl (7.0.024) id 413E2E53000FC597; Wed, 15 Sep 2004 14:44:52 -0400 Received: from 216.155.88.75.dsl.surnet.cl (216.155.85.183) by cluster.surnet.cl (7.0.024) (authenticated as alvherre@surnet.cl) id 4134D322001B16EE; Wed, 15 Sep 2004 14:47:09 -0400 Received: by 216.155.88.75.dsl.surnet.cl (Postfix, from userid 500) id 555D01958B; Wed, 15 Sep 2004 14:47:39 -0400 (CLT) Date: Wed, 15 Sep 2004 14:47:39 -0400 From: Alvaro Herrera To: "Jeffrey W. Baker" Cc: pgsql-general@postgresql.org Subject: Re: disk performance benchmarks Message-ID: <20040915184739.GF4607@dcc.uchile.cl> References: <1095185498.5792.12.camel@localhost.localdomain> <003801c49b07$f33b6990$ad01a8c0@zaphod> <1095264696.8243.0.camel@localhost.localdomain> <1095273378.9384.0.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1095273378.9384.0.camel@localhost.localdomain> User-Agent: Mutt/1.5.6i 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: 200409/726 X-Sequence-Number: 65932 On Wed, Sep 15, 2004 at 11:36:18AM -0700, Jeffrey W. Baker wrote: > On Wed, 2004-09-15 at 10:53, Vivek Khera wrote: > > >>>>> "JWB" == Jeffrey W Baker writes: > > > > JWB> All these replies are really interesting, but the point is not that my > > JWB> RAIDs are too slow, or that my CPUs are too slow. My point is that, for > > JWB> long stretches of time, by database doesn't come anywhere near using the > > JWB> capacity of the hardware. And I think that's odd and would like to > > JWB> config it to "false". > > > > Have you tried to increase your checkpoing_segments? I get the > > suspicion that you're checkpointing every 3 minutes constantly. > > You'll have to restart the postmaster for this setting to take effect, > > I believe. > > I have checkpoint_segments set to 24, but I get the feeling that making > it larger may have the opposite effect of what I want, by extending the > period during which the DB makes no progress. It sounds strange that the DB stops doing anything while the checkpoint is in progress. Have you tried poking at pg_locks during that interval? -- Alvaro Herrera () "La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"