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

Mayuresh,

comments in-lined, below ...

----- Original Message ----
> From: Mayuresh Nirhali <Mayuresh(dot)Nirhali(at)Sun(dot)COM>
> To: jiniusatwork-postgresql(at)yahoo(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> Sent: Thursday, January 31, 2008 6:23:23 AM
> Subject: Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
>
> Bob,
>
> First,
>
Which
>
exact
>
version
>
of
>
S10
>
are
>
you
>
using
>
?

> more /etc/release
Solaris 10 8/07 s10s_u4wos_12b SPARC
Copyright 2007 Sun Microsystems, Inc. All Rights Reserved.
Use is subject to license terms.
Assembled 16 August 2007

> pkginfo SUNWpostgr-server
system SUNWpostgr-server The programs needed to create and run a PostgreSQL 8.1.10 server

>
> In
>
general,
>
I
>
have
>
seen
>
having
>
logs
>
and
>
data
>
on
>
different
>
pools
>
helps.
> Also,
>
let
>
us
>
know
>
your
>
wal
>
tunning
>
parameters
>
like
>
commit_delay,
>
fsync.
> If
>
you
>
are
>
using
>
S10u4,
>
setting
>
commit_delay
>
to
>
a
>
non
>
zero
>
number
>
should
> help
>
get
>
better
>
performance.
>
Thanks for the info. I'll give it a shot and let you know.
Bob