Re: [PERFORM] wal sync method

2006-02-28 Thread Tom Lane
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

Re: [PERFORM] wal sync method

2006-02-27 Thread Javier Somoza
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

Re: [PERFORM] wal sync method

2006-02-27 Thread Bruce Momjian
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