X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 63FF711F6BFF for ; Wed, 5 Apr 2006 22:23:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72575-06 for ; Wed, 5 Apr 2006 22:23:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [203.96.152.180]) by postgresql.org (Postfix) with ESMTP id 5193A11F6BD9 for ; Wed, 5 Apr 2006 22:23:56 -0300 (ADT) Received: from smtp-2.paradise.net.nz (tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IXA0029Y17WKC@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Thu, 06 Apr 2006 13:23:56 +1200 (NZST) Received: from [192.168.1.11] (218-101-29-161.dsl.clear.net.nz [218.101.29.161]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id E11626F6880; Thu, 06 Apr 2006 13:23:55 +1200 (NZST) Date: Thu, 06 Apr 2006 13:23:54 +1200 From: Mark Kirkwood Subject: Re: bad performance on Solaris 10 In-reply-to: <1144279780.5133.19.camel@dell.home.lan> To: Chris Mair Cc: pgsql-performance@postgresql.org, josh@agliodbs.com, llonergan@greenplum.com Message-id: <44346DAA.2080905@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (X11/20051106) References: <1144111178.3723.80.camel@dell.home.lan> <1144272685.4562.43.camel@dell.home.lan> <443451F0.5060605@paradise.net.nz> <1144279780.5133.19.camel@dell.home.lan> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.165 required=5 tests=[AWL=0.165] X-Spam-Score: 0.165 X-Spam-Level: X-Archive-Number: 200604/85 X-Sequence-Number: 18169 Chris Mair wrote: > > (but note the other mail about wal_sync_method = fsync) > Yeah - looks good! (is the default open_datasync still?). Might be worth trying out the fdatasync method too (ISTR this being quite good... again on Solaris 8, so things might have changed)! Cheers Mark