Re: bad performance on Solaris 10

Chris Mair wrote:
> Hi,
>
> thanks for all replys.
>
> I've done a few tests.
>
> Remounting the fs where $PGDATA lives with "forcedirectio"
> (together with logging, that is default) did not help
> (if not harm...) performance.
>
>

Sure - forcedirectio on the entire $PGDATA is a definite loss, you only
want it on $PGDATA/pg_xlog. The usual way this is accomplished is by
making a separate filsystem for pg_xlog and symlinking from $PGDATA.

Did you try the other option of remounting the fs for $PGDATA without
logging or forcedirectio?

Cheers

Mark