- Original Message
From: Greg Smith <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Sunday, February 3, 2008 8:43:28 PM
Subject: Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global
zones on Solaris?
On
Thu,
31
Jan
2008,
[EMAIL PROTECTE
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
As it turns out, I think the ZFS-on-RAID setup I had is the problem[1]. After
running some more I/O tests w
[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.
Bob
--
Mayuresh,
comments in-lined, below ...
- Original Message
> From: Mayuresh Nirhali <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, January 31, 2008 6:23:23 AM
> Subject: Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global
>
In the hopes that someone has already blazed this trail ...
I'm running Postgresql (v8.1.10) on Solaris 10 (Sparc) from within a non-global
zone. I originally had the database "storage" in the non-global zone (e.g.
/var/local/pgsql/data on a UFS filesystem) and was getting performance of "X"
(
