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