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 1BE4B11F6CEA for ; Thu, 6 Apr 2006 03:01:43 -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 52359-01-3 for ; Thu, 6 Apr 2006 03:01:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from my.endian.it (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id 8734B11F6CE0 for ; Thu, 6 Apr 2006 03:01:30 -0300 (ADT) Received: from dell.home.lan (host14-128.pool8251.interbusiness.it [82.51.128.14]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k3673xr26806; Thu, 6 Apr 2006 09:03:59 +0200 Subject: Re: bad performance on Solaris 10 From: Chris Mair To: Josh Berkus Cc: Mark Kirkwood , pgsql-performance@postgresql.org, llonergan@greenplum.com In-Reply-To: <200604052135.14326.josh@agliodbs.com> 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> Content-Type: text/plain Date: Thu, 06 Apr 2006 08:01:09 +0200 Message-Id: <1144303269.3718.4.camel@dell.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200604/92 X-Sequence-Number: 18176 > > 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)! > > I was just talking to a member of the Solaris-UFS team who recommended that we > test fdatasync. 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! Bye, Chris.