-----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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
