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 9175C11F6983 for ; Thu, 6 Apr 2006 04:37:12 -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 76229-03 for ; Thu, 6 Apr 2006 04:37:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from brmea-mail-1.sun.com (brmea-mail-1.Sun.COM [192.18.98.31]) by postgresql.org (Postfix) with ESMTP id 1142411F6AB8 for ; Thu, 6 Apr 2006 04:37:09 -0300 (ADT) Received: from phys-d3-ha21sca-1 ([129.145.155.163]) by brmea-mail-1.sun.com (8.12.10/8.12.9) with ESMTP id k367b8Gx009283 for ; Thu, 6 Apr 2006 01:37:09 -0600 (MDT) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IXA00M01IGRTB@ha21sca-mail1.sfbay.sun.com> (original mail from Robert.Lor@Sun.COM) for pgsql-performance@postgresql.org; Thu, 06 Apr 2006 00:37:05 -0700 (PDT) Received: from [129.150.12.119] (vpn-129-150-12-119.SFBay.Sun.COM [129.150.12.119]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0IXA00M2EIHSTI@ha21sca-mail1.sfbay.sun.com>; Thu, 06 Apr 2006 00:37:05 -0700 (PDT) Date: Thu, 06 Apr 2006 00:36:37 -0700 From: Robert Lor Subject: Re: bad performance on Solaris 10 In-reply-to: <1144303269.3718.4.camel@dell.home.lan> To: Chris Mair Cc: Josh Berkus , Mark Kirkwood , pgsql-performance@postgresql.org, llonergan@greenplum.com Message-id: <4434C505.1000205@sun.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.7) Gecko/20050913 References: <1144111178.3723.80.camel@dell.home.lan> <1144279780.5133.19.camel@dell.home.lan> <44346DAA.2080905@paradise.net.nz> <200604052135.14326.josh@agliodbs.com> <1144303269.3718.4.camel@dell.home.lan> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.121 required=5 tests=[AWL=0.120, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.121 X-Spam-Level: X-Archive-Number: 200604/99 X-Sequence-Number: 18183 Chris Mair wrote: >Ok, so I did a few runs for each of the sync methods, keeping all the >rest constant and got this: > >open_datasync 0.7 >fdatasync 4.6 >fsync 4.5 >fsync_writethrough not supported >open_sync 0.6 > >in arbitrary units - higher is faster. > >Quite impressive! > > > > Chris, Just to make sure the x4100 config is similar to your Linux system, can you verify the default setting for disk write cache and make sure they are both enabled or disabled. Here's how to check in Solaris. As root, run "format -e" -> pick a disk -> cache -> write_cache -> display Not sure how to do it on Linux though! Regards, -Robert