From: Alvaro Herrera <alvherre@commandprompt.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Chris Mair <list@1006.org>
Cc: pgsql-performance@postgresql.org, markir@paradise.net.nz, Josh Berkus <josh@agliodbs.com>
Subject: Re: bad performance on Solaris 10
Date: Wed, 5 Apr 2006 17:48:24 -0400
Message-ID: <20060405214824.GB13673@surnet.cl> (raw)
In-Reply-To: <C059874E.20ECE%llonergan@greenplum.com>
References: <1144272685.4562.43.camel@dell.home.lan>
<C059874E.20ECE%llonergan@greenplum.com>
Luke Lonergan wrote:
> Chris,
>
> On 4/5/06 2:31 PM, "Chris Mair" <list@1006.org> wrote:
>
> > Doing what http://blogs.sun.com/roller/page/jkshah suggests:
> > wal_sync_method = fsync (unchanged)
> > wal_buffers = 128 (was 8)
> > checkpoint_segments = 128 (was 3)
> > bgwriter_all_percent = 0 (was 0.333)
> > bgwriter_all_maxpages = 0 (was 5)
> > and leaving everything else default (solarispackages from pgfoundry)
> > increased performance ~ 7 times!
>
> In the recent past, Jignesh Shaw of Sun MDE discovered that changing the
> bgwriter_* parameters to zero had a dramatic positive impact on performance.
This essentially means stopping all bgwriter activity, thereby deferring
all I/O until checkpoint. Was this considered? With
checkpoint_segments to 128, it wouldn't surprise me that there wasn't
any checkpoint executed at all during the whole test ...
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
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: alvherre@commandprompt.com, llonergan@greenplum.com, list@1006.org, josh@agliodbs.com
Subject: Re: bad performance on Solaris 10
In-Reply-To: <20060405214824.GB13673@surnet.cl>
* 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