> > I am just suggesting that instead of flushing the log on every > > transaction end, just do it every X seconds. > > Or maybe more practical is, when the log buffer fills. > And of course during checkpoints. Also before backend's going to write dirty buffer from pool to system cache - changes must be logged before reflected in data files. Vadim
- Re: [HACKERS] WAL fsync schedul... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Peter Eisentraut
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] ... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] ... Tom Lane
- Re: [HACKERS] RE: [COMMITTERS] ... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] ... Tom Lane
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/t... Mikheev, Vadim
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/t... Mikheev, Vadim