Re: Postgres performance on Veritas VxVM - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greg Smith:
> What you should do is the following:

> postgresql.conf:  wal_sync_method = open_datasync
> /sql/pg_xlog:  'noatime,cio,mincache=direct,convosync=direct

> That should work quite well.

Thanks.  That reduced the import time to about 4hr 30 minutes.  However,
this is still much slower than using VxFS with plain disks.  Any other
ideas?

I'm now running a test using VxFS on SVM soft partitions to see if that
improves performance at all (but I'd much rather have the flexibility of
VxVM).

    - river.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (HP-UX)

iEYEARECAAYFAksWlf0ACgkQIXd7fCuc5vLDQQCghI3Dm8/GRuDVOucrYlQoq5jS
sk0AoLR0SJyt+aK7k1F+iTEQ/t3Qto+U
=y3ed
-----END PGP SIGNATURE-----