Bruce Momjian <[EMAIL PROTECTED]> writes: > It is hard for me to imagine O_* being slower than fsync(), Not hard at all --- if we're writing multiple xlog blocks per transaction, then O_* constrains the sequence of operations more than we really want. Changing xlog.c to combine writes as much as possible would reduce this problem, but not eliminate it. Besides, the entire object of this exercise is to work around an unexpected inefficiency in some kernels' implementations of fsync/fdatasync (viz, scanning over lots of not-dirty buffers). Who's to say that there might not be inefficiencies in other platforms' implementations of the O_* options? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
- Re: [HACKERS] Allowing WAL fsync to be done via ... Bruce Momjian
- Re: [HACKERS] Allowing WAL fsync to be done via ... Peter Eisentraut
- 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