Re: RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c) - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c)
Date
Msg-id 20001107101133F.t-ishii@sra.co.jp
Whole thread Raw
In response to RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c)  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
> > > 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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Darn, long option emulation doesn't work on FreeBSD
Next
From: Tatsuo Ishii
Date:
Subject: Re: How to get around LIKE inefficiencies?