From: Chris Mair <list@1006.org>
To: Josh Berkus <josh@agliodbs.com>
Cc: Mark Kirkwood <markir@paradise.net.nz>
Cc: pgsql-performance@postgresql.org
Cc: llonergan@greenplum.com
Subject: Re: bad performance on Solaris 10
Date: Thu, 06 Apr 2006 08:01:09 +0200
Message-ID: <1144303269.3718.4.camel@dell.home.lan> (raw)
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>
> > 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: list@1006.org, josh@agliodbs.com, markir@paradise.net.nz, llonergan@greenplum.com
Subject: Re: bad performance on Solaris 10
In-Reply-To: <1144303269.3718.4.camel@dell.home.lan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox