PFC [EMAIL PROTECTED] writes:
Just a stupid question about the various fsync settings.
There is fsync=off, but is there fsync=fflush ?
fflush would mean only an OS crash could cause data loss,
I think.it could be useful for some applications where you need a speed
Hi Evgeny
Im also testing what fsync method to use and using this program (http://archives.postgresql.org/pgsql-performance/2003-12/msg00191.php)
a bit modified and i get this results:
write 0.36
write fsync 0.006796
write fdatasync 0.001001
write (O_FSYNC) 0.005761
write
Use whichever sync method is fastest for you. They are all reliable,
except turning fsync off.
---
Javier Somoza wrote:
Hi Evgeny
Im also testing what fsync method to use and using this program