Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: jiniusatwork-postgresql(at)yahoo(dot)com
Subject: Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
Date: 2008-02-02 15:44:57
Message-ID: 200802021044.58133.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 31 January 2008 07:08, jiniusatwork-postgresql(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-02-02 16:37:02 Re: Log query statistics
Previous Message Bill Moran 2008-02-02 14:55:40 Re: [OT] "advanced" database design (long)