Postgres Pro
Downloads
Home   >   mailing lists

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

From Florian Weimer
Subject Re: fsync on ext4 does not work
Date
Msg-id 821us0lfb7.fsf@mid.bfk.de
Whole thread Raw
In response to fsync on ext4 does not work  (Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>)
Responses Re: fsync on ext4 does not work  (Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>)
List pgsql-general
Tree view 
* Havasvölgyi Ottó:

> 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?

Did you mount your ext4 file system with the nobarrier option?

By default, ext4 is supposed to cope properly with hard disk caches,
unless the drive is lying about completing writes (but in that case,
disabling write caching is probably not going to help much with
reliability, either).

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-general by date:

Previous
From: Daniel Migowski
Date:
Subject: Feature Request: Better handling of foreign keys in DELETE statements
Next
From: Alban Hertroys
Date:
Subject: Re: Changing Passwords as Encrypted not Clear-Text