Re: bad performance on Solaris 10 - Mailing list pgsql-performance

From Chris Mair
Subject Re: bad performance on Solaris 10
Date
Msg-id 1144703122.3686.7.camel@dell.home.lan
Whole thread Raw
In response to Re: bad performance on Solaris 10  (Chris Mair <list@1006.org>)
List 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.






pgsql-performance by date:

Previous
From: Brendan Duddridge
Date:
Subject: Re: OT: Data structure design question: How do they count so fast?
Next
From: Tom Lane
Date:
Subject: Re: Encouraging multi-table join order