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

From Bruce Momjian
Subject Re: bad performance on Solaris 10
Date
Msg-id 200604130839.k3D8dZQ26118@candle.pha.pa.us
Whole thread Raw
In response to Re: bad performance on Solaris 10  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Responses Re: bad performance on Solaris 10
Re: bad performance on Solaris 10
List pgsql-performance
Jignesh K. Shah wrote:
>
> Bruce,
>
> Hard to answer that... People like me who know and love PostgreSQL and
> Solaris finds this as an opportunity to make their favorite database
> work best on their favorite operating system.
>
> Many times PostgreSQL has many things based on assumption that it will
> run on  Linux and it is left to Solaris to emulate that behavior.That
> said there are ways to improve performance even on UFS on Solaris, it
> just requires more tweaks.
>
> Hopefully this will lead to few Solaris friendly default values  like
> fsync/odatasync :-)

Yes, if someone wants to give us a clear answer on which wal_sync method
is best on all versions of Solaris, we can easily make that change.

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: bad performance on Solaris 10
Next
From: Markus Schaber
Date:
Subject: Re: Better index stategy for many fields with few values