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

From Mikheev, Vadim
Subject RE: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D317E@sectorbase1.sectorbase.com
Whole thread Raw
Responses Re: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> Earlier, Vadim was talking about arranging to share fsyncs of the WAL
> log file across transactions (after writing your commit record to the
> log, sleep a few milliseconds to see if anyone else fsyncs before you
> do; if not, issue the fsync yourself).  That would offer less-than-
> one-fsync-per-transaction performance without giving up any 
> guarantees.
> If people feel a compulsion to have a tunable parameter, let 'em tune
> the length of the pre-fsync sleep ...

Already implemented (without ability to tune this parameter - 
xact.c:CommitDelay, - yet). Currently CommitDelay is 5, so
backend sleeps 1/200 sec before checking/forcing log fsync.

Vadim


pgsql-hackers by date:

Previous
From: markw
Date:
Subject: Re: Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL
Next
From: Peter Eisentraut
Date:
Subject: Re: Syslog Facility Patch