> Based on the tests we did last week, it seems clear than on many > platforms it's a win to sync the WAL log by writing it with open() > option O_SYNC (or O_DSYNC where available) rather than > issuing explicit fsync() (resp. fdatasync()) calls. I don't remember big difference in using fsync or O_SYNC in tfsync tests. Both depend on block size and keeping in mind that fsync allows us syncing after writing *multiple* blocks I would either use fsync as default or don't deal with O_SYNC at all. But if O_DSYNC is defined and O_DSYNC != O_SYNC then we should use O_DSYNC by default. (BTW, we didn't compare fdatasync and O_SYNC yet). Vadim ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
- Re: [HACKERS] Allowing WAL fsync to be done via O_SYNC Bruce Momjian
- Re: [HACKERS] Allowing WAL fsync to be done via O_SY... Tom Lane
- Re: [HACKERS] Allowing WAL fsync to be done via ... Bruce Momjian
- Re: [HACKERS] Allowing WAL fsync to be done ... Tom Lane
- Re: [HACKERS] Allowing WAL fsync to be d... Bruce Momjian
- Re: [HACKERS] Allowing WAL fsync to... Tom Lane
- Re: [HACKERS] Allowing WAL fsyn... Bruce Momjian
- Re: [HACKERS] Allowing WAL fsyn... Tom Lane
- Re: [HACKERS] Allowing WAL fsyn... Bruce Momjian
- Re: [HACKERS] Allowing WAL fsync to be done via O_SYNC Mikheev, Vadim
- Re: [HACKERS] Allowing WAL fsync to be done via O_SY... Tom Lane
- Re: [HACKERS] Allowing WAL fsync to be done via ... Alfred Perlstein
- Re: [HACKERS] Allowing WAL fsync to be done ... Peter Eisentraut
- Re: [HACKERS] Allowing WAL fsync to be d... Alfred Perlstein
- Re: [HACKERS] Allowing WAL fsync to... Tom Lane
- Re: [HACKERS] Allowing WAL fsyn... Alfred Perlstein
- Re: [HACKERS] Allowing WAL fsync to be done ... Lamar Owen
- Re: [HACKERS] Allowing WAL fsync to be done via ... Peter Eisentraut
- Re: [HACKERS] Allowing WAL fsync to be done ... Tom Lane
- [HACKERS] Re: Allowing WAL fsync to be d... Thomas Lockhart