fsync on ext4 does not work - Mailing list pgsql-general

From Havasvölgyi Ottó
Subject fsync on ext4 does not work
Date
Msg-id CAOryeA1EoiFpmG6HmQakWYWtH6vqxLPxw3JeUocnjpnBuySf9A@mail.gmail.com
Whole thread Raw
Responses Re: fsync on ext4 does not work
Re: fsync on ext4 does not work
Re: fsync on ext4 does not work
List pgsql-general
Hi all,

Somewhy fsync does not work for me.

PgSql 9.1.2

Debian, 2.6.32 kernel

WAL filesystem: ext4 with defaults

config:
fsync=on
sync_commit=on
wal_sync_method=fsync


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?

Have you any idea why?

Thanks,
Otto

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Changing Passwords as Encrypted not Clear-Text
Next
From: MURAT KOÇ
Date:
Subject: Re: Changing Passwords as Encrypted not Clear-Text