From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
Subject: Re: bad performance on Solaris 10
Date: Wed, 12 Apr 2006 15:49:14 -0700
User-Agent: KMail/1.8
Cc: pgsql-performance@postgresql.org
References: <C062CEC5.216CA%llonergan@greenplum.com>
In-Reply-To: <C062CEC5.216CA%llonergan@greenplum.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
To: Undisclosed.Recipients: ;
Message-Id: <200604121549.14328.josh@agliodbs.com>

People,

> Lately I find people are not so receptive to VxFS, and Sun is promoting
> ZFS, and we don't have a reasonable near term option for Raw IO in
> Postgres, so we need to work to find a reasonable path for Solaris users
> IMO. =A0The long delays in ZFS production haven't helped us there, as the
> problems with UFS are severe.

=46WIW, I'm testing on ZFS now.  But it's not stable yet.  People are welco=
me=20
to join the Solaris 11 beta program.

In the near term, there are fixes to be made both in PostgreSQL=20
configuration and in Solaris configuration.  Also, some of the work being=20
done for 8.2 ... the external sort work done by Simon and sponsored by=20
GreenPlum, and the internal sort work which Jonah and others are doing ...=
=20
will improve things on Solaris as our sort issues hit Solaris harder than=20
other OSes.

Expect lots more info on performance config for Solaris from me & Robert in=
=20
the next few weeks.=20

=2D-=20
=2D-Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco