[GENERAL] Postgres performance on Veritas VxVM

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm running Postgres 8.3.7 on Solaris 10 x64, using VxFS/VxVM 5.0 MP3. I'm trying to determine the best storage configuration for my workload, so I ran some tests of Postgres performance with various combinations of VM and filesystem. What I noti

Re: [GENERAL] Postgres performance on Veritas VxVM

-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

Re: [GENERAL] Postgres performance on Veritas VxVM

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greg Smith: > Flexibility is often expensive from a performance point of view. We > regularly tell people here that they have to avoid using Linux's LVM for > similar reasons--while it shouldn't be so slow, it is. Nothing you can > do about it