Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris? - Mailing list pgsql-general

From Robert Treat
Subject Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
Date
Msg-id 200802021044.58133.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?  (jiniusatwork-postgresql@yahoo.com)
List pgsql-general
On Thursday 31 January 2008 07:08, jiniusatwork-postgresql@yahoo.com wrote:
> [Following up on my own message.]
>
>
> Also,
>
> > let
> >
> > us
> >
> > know
> >
> > your
> >
> > wal
> >
> > tunning
> >
> > parameters
> >
> > like
> >
> > commit_delay,
> >
> > fsync.
>
> I haven't done any tuning as of yet. I'm running with the default settings
> produced by initdb.
>

Don't even bother trying to tune zfs untill after you've tuned postgres,
otherwise your wasting your time.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: [OT] "advanced" database design (long)
Next
From: "Scott Marlowe"
Date:
Subject: Re: Log query statistics