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