Re: CommitDelay performance improvement

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: CommitDelay performance improvement
Дата
Msg-id 200102232005.PAA22767@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: CommitDelay performance improvement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Is there significant time between entry of CommitTransaction() and the
> > fsync()?  Maybe not.
> 
> I doubt it.  No I/O anymore, anyway, unless the commit record happens to
> overrun an xlog block boundary.

That's what I was afraid of.  Since we don't write the dirty blocks to
the kernel anymore, we don't really have much happening before someone
says they are about to commit.  In the old days, we were write()'ing
those buffers, and we had some delay and kernel calls in there.

Guess that idea is dead.

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Lock structures
Следующее
От: Bruce Momjian
Дата:
Сообщение: Lock structures