From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Chris Mair <list@1006.org>
Cc: markir@paradise.net.nz
Cc: llonergan@greenplum.com
Subject: Re: bad performance on Solaris 10
Date: Wed, 5 Apr 2006 21:32:16 -0700
Message-ID: <200604052132.16434.josh@agliodbs.com> (raw)
In-Reply-To: <1144272685.4562.43.camel@dell.home.lan>
References: <1144111178.3723.80.camel@dell.home.lan>
<1144272685.4562.43.camel@dell.home.lan>
Chris,
> Remounting the fs where $PGDATA lives with "forcedirectio"
> (together with logging, that is default) did not help
> (if not harm...) performance.
Not all of PG. JUST pg_xlog. forcedirectio is only a good idea for the xlog.
> Quickly playing around with wal_buffers on Linux and Mac OS X
> I see it influences the performance of my test a bit, maybe in the
> 10-20% range (I'm really doing quick tests, nothing systematic),
> but nowhere near as spectacularly as on Solaris.
>
> I'm happy so far, but I find it very surprising that this single
> parameter has such an impact (only on) Solaris 10.
That *is* interesting. I hadn't tested this previously specifically on
Solaris.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, list@1006.org, markir@paradise.net.nz, llonergan@greenplum.com
Subject: Re: bad performance on Solaris 10
In-Reply-To: <200604052132.16434.josh@agliodbs.com>
* 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