Re: bad performance on Solaris 10

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Chris Mair <list(at)1006(dot)org>, pgsql-performance(at)postgresql(dot)org, markir(at)paradise(dot)net(dot)nz, Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: bad performance on Solaris 10
Date: 2006-04-12 19:56:17
Message-ID: 200604121956.k3CJuH717290@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Luke Lonergan wrote:
> Alvaro,
>
> On 4/5/06 2:48 PM, "Alvaro Herrera" <alvherre(at)commandprompt(dot)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. +

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-04-12 20:44:22 Re: Better index stategy for many fields with few values
Previous Message Craig A. James 2006-04-12 17:36:28 Re: FOREIGN KEYS vs PERFORMANCE