Re: Best setting for wal_sync_method

Speaking to the sys admins we found that the file system where the WAL was written to did not have direct_io and hence all writes were getting buffered. So we enabled direct_io on that FS and now writes are order of magnitude slower (5x times).

It seems PG already uses O_DIRECT for WAL. So is the enabling of direct_io in the mount options of the FS totally redundant. It definitely has a serious performance impact.

Thanks

From: srkrishna(at)outlook(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Best setting for wal_sync_method
Date: Thu, 7 May 2015 09:36:36 -0400

On RHEL 6.4 which is the best setting for wal_sync_method for write intensive operations. Is the default fdatasync good for all conditions, including reliability.

Thanks