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

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D317E@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответы Re: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: markw
Дата:
Сообщение: Re: Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Syslog Facility Patch