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

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

Andreas

[ Charset ISO-8859-1 unsupported, converting... ]
> 
> > 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.

Log filling is too abritrary.  If I commit something, and nothing
happens for 2 hours, we should commit that transaction.

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