- 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
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
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
zones
[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
---(end of
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