| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Havasvölgyi Ottó <havasvolgyi(dot)otto(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: fsync on ext4 does not work |
| Date: | 2011-12-19 16:03:08 |
| Message-ID: | 821us0lfb7.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* 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(at)bfk(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2011-12-19 16:05:31 | Re: Changing Passwords as Encrypted not Clear-Text |
| Previous Message | Daniel Migowski | 2011-12-19 16:01:04 | Feature Request: Better handling of foreign keys in DELETE statements |