From: | Chris Mair <list(at)1006(dot)org> |
---|---|
To: | Robert Lor <Robert(dot)Lor(at)Sun(dot)COM> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>, pgsql-performance(at)postgresql(dot)org, llonergan(at)greenplum(dot)com |
Subject: | Re: bad performance on Solaris 10 |
Date: | 2006-04-10 21:05:22 |
Message-ID: | 1144703122.3686.7.camel@dell.home.lan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> > Chris,
> > Just to make sure the x4100 config is similar to your Linux system, can
> > you verify the default setting for disk write cache and make sure they
> > are both enabled or disabled. Here's how to check in Solaris.
> > As root, run "format -e" -> pick a disk -> cache -> write_cache -> display
> >
> > Not sure how to do it on Linux though!
> >
> > Regards,
> > -Robert
>
> I don't have access to the machine for the next few days due to eh...
> let's call it firewall accident ;), but it might very well be that it
> was off on the x4100 (I know it's on the smaller Linux box).
>
> That together with the bad default sync method can definitely explain
> the strangely slow out of box performance I got.
>
> So thanks again for explaining this to me :)
>
> Bye, Chris.
Just for completeness:
I checked now using the above commands and can confirm the write cache
was disabled on the x4100 and was on on Linux.
Bye, Chris.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-04-10 23:12:36 | Re: Encouraging multi-table join order |
Previous Message | Brendan Duddridge | 2006-04-10 20:34:02 | Re: OT: Data structure design question: How do they count so fast? |