Thread: AW: AW: RE: [COMMITTERS] pgsql/src/backend/access/trans am ( xact.c xlog.c)

AW: AW: RE: [COMMITTERS] pgsql/src/backend/access/trans am ( xact.c xlog.c)

From
Zeugswetter Andreas SB
Date:
> > Or maybe more practical is, when the log buffer fills. 
> > And of course during checkpoints.
> 
> Log filling is too abritrary.  If I commit something, and nothing
> happens for 2 hours, we should commit that transaction.

Checkpoint, as I said ?

Andreas


Re: AW: AW: RE: [COMMITTERS] pgsql/src/backend/access/trans am ( xact.c xlog.c)

From
Bruce Momjian
Date:
[ Charset ISO-8859-1 unsupported, converting... ]
> 
> > > Or maybe more practical is, when the log buffer fills. 
> > > And of course during checkpoints.
> > 
> > Log filling is too abritrary.  If I commit something, and nothing
> > happens for 2 hours, we should commit that transaction.
> 
> Checkpoint, as I said ?

Sorry.  My mistake.  Of course, checkpoint timing is fine.

--  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