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

From Josh Berkus
Subject Re: bad performance on Solaris 10
Date
Msg-id 200604141201.26080.josh@agliodbs.com
Whole thread Raw
In response to Re: bad performance on Solaris 10  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
Jignesh,

> Don't get me wrong. As Luke mentioned it took a while to get the
> potential of PostgreSQL on Solaris and people like me start doing other
> complex  workarounds in Solaris like "forcedirectio", etc. (Yeah I did a
> test, if you force  fsync as wal_sync_method  while on  Solaris, then
> you may not even require to do forcedirectio of your $PGDATA/pg_xlogs to
> get back the lost performance)

I didn't see these later test results.   Can you link?

Also, I presume this was on DW, and not on OLTP, yes?

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Inserts optimization?
Next
From: Michael Stone
Date:
Subject: Re: Inserts optimization?