> > > New CHECKPOINT command. > > > Auto removing of offline log files and creating new file > > > at checkpoint time. Can you tell me how to use CHECKPOINT please? > > Is this the same as a SAVEPOINT? > > No. Checkpoints are to speedup after crash recovery and > to remove/archive log files. With WAL server doesn't write > any datafiles on commit, only commit record goes to log > (and log fsync-ed). Dirty buffers remains in memory long Is log fsynced even I turn of -F? -- Tatsuo Ishii
- [HACKERS] Re: [COMMITTERS] pgsql/src/backend/access/trans... Peter Eisentraut
- [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/... Mikheev, Vadim
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend... Tatsuo Ishii
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/acc... Mikheev, Vadim
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend... Bruce Momjian
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend... Tatsuo Ishii
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/bac... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] pgsq... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] pgsq... Tom Lane
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTE... Tom Lane
- Re: [HACKERS] RE: [COMMITTE... Bruce Momjian