Brandon Metcalf wrote:
We've recently moved our pgsql installation and DBs to a Solaris 8
machine with striped and mirrored ufs filesystem that houses the DB
data.  We are now seeing terrible performance and the bottleneck is no
doubt disk I/O.

We've tried modifying a tunables related to ufs, but it doesn't seem
to be helping.

Is there anything we should be looking at that is specifically related
to ufs filesystems on Solaris 8 or possibly something in general that
would improve performance?


I found that mounting the filesystem that contains the PGDATA directory (probably only the pg_xlog directory in fact) without logging improved things a great deal (assuming you are using logging that is...).

In addition changing the postgresql.conf parameter wal_sync_method from the default of open_datasync to fdatasync improved things a bit more. However I seem to recall a posting suggesting the opposite! feel free to experiment and let us know!


P.s : original tests on Solaris 8,

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

Reply via email to