On 19 Prosinec 2011, 16:52, Havasvölgyi Ottó wrote:
> config:
> fsync=on
> sync_commit=on
> wal_sync_method=fsync
I don't think you need to set wal_sync_method, comment it out.
> Even though the TPS in pgbench about 700 with 1 client.
> I have tried other sync methods (fdatasync, open_sync), but all are
> similar.
> Should I disable write cache on HDD to make it work?
Yes, disable that.
> Have you any idea why?
What scale factor have you used with pgbench? And how long are the pgbench
runs? The smaller the data set, the more it will be affected by the write
cache.
Tomas