[ Charset ISO-8859-1 unsupported, converting... ]
> > > > > 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?
>
> You shouldn't normally use it - postmaster will start backend
> each 3-5 minutes to do this automatically.
>
> > > > 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?
>
> Yes, though we can change this. We also can implement now
> feature that Bruce wanted so long and so much -:) -
> fsync log not on each commit but each ~ 5sec, if
> losing some recent commits is acceptable.
Great. I think this middle ground is something we could never address
before.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026