Bruce Momjian <[EMAIL PROTECTED]> writes: >> I have to agree with Alfred here: this does not sound like a feature, >> it sounds like a horrid hack. You're giving up *all* consistency >> guarantees for a performance gain that is really going to be pretty >> minimal in the WAL context. > It does not give up consistency. The db is still consistent, it is just > consistent from a few seconds ago, rather than commit time. No, it isn't consistent. Without the fsync you don't know what order the kernel will choose to plop down WAL log blocks in; you could end up with a corrupt log. (Actually, perhaps that could be worked around if the log blocks are suitably marked so that you can tell where the last sequentially valid one is. I haven't looked at the log structure in any detail...) regards, tom lane
- [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/trans... Mikheev, Vadim
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/t... Mikheev, Vadim
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/acc... Bruce Momjian
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/acc... Tatsuo Ishii
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/bac... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src... Tom Lane
- Re: [HACKERS] RE: [COMMITTERS] pgsq... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Tom Lane
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/bac... Tatsuo Ishii