Re: bad performance on Solaris 10

From: Chris Mair <list(at)1006(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>, pgsql-performance(at)postgresql(dot)org, llonergan(at)greenplum(dot)com
Subject: Re: bad performance on Solaris 10
Date: 2006-04-06 06:01:09
Message-ID: 1144303269.3718.4.camel@dell.home.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> > 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2006-04-06 06:44:52 Re: Sun Fire T2000 and PostgreSQL 8.1.3
Previous Message Leigh Dyer 2006-04-06 04:47:00 Re: Sun Fire T2000 and PostgreSQL 8.1.3