From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Alvaro Herrera <alvherre@commandprompt.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, 12 Apr 2006 15:56:17 -0400 (EDT)
Message-ID: <200604121956.k3CJuH717290@candle.pha.pa.us> (raw)
In-Reply-To: <C0598B28.20EDA%llonergan@greenplum.com>
Luke Lonergan wrote:
> Alvaro,
>
> On 4/5/06 2:48 PM, "Alvaro Herrera" <alvherre@commandprompt.com> wrote:
>
> > 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 ...
>
> Yes, many things about the Solaris UFS filesystem caused a great deal of
> pain over the 10 months of experiments we ran with Sun MDE. Ultimately, the
> conclusion was that ZFS is going to make all of the pain go away.
>
> In the meantime, all you can do is tweak up UFS and avoid I/O as much as
> possible.
It is hard to imagine why people spend so much time modifying Sun
machines run with acceptable performance when non-Sun operating systems
work fine without such hurtles.
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
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: pgman@candle.pha.pa.us, llonergan@greenplum.com, alvherre@commandprompt.com, list@1006.org, josh@agliodbs.com
Subject: Re: bad performance on Solaris 10
In-Reply-To: <200604121956.k3CJuH717290@candle.pha.pa.us>
* 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