Re: bad performance on Solaris 10 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: bad performance on Solaris 10
Date
Msg-id 200604121549.14328.josh@agliodbs.com
Whole thread Raw
In response to Re: bad performance on Solaris 10  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: bad performance on Solaris 10
List pgsql-performance
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.  The long delays in ZFS production haven't helped us there, as the
> problems with UFS are severe.

FWIW, I'm testing on ZFS now.  But it's not stable yet.  People are welcome
to join the Solaris 11 beta program.

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

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

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Better index stategy for many fields with few
Next
From: "Jim Nasby"
Date:
Subject: Re: Better index stategy for many fields with few values