Re: COMMIT NOWAIT Performance Option

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: COMMIT NOWAIT Performance Option
Дата
Msg-id 200702272217.l1RMHjZ15874@momjian.us
обсуждение исходный текст
Ответ на Re: COMMIT NOWAIT Performance Option  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: COMMIT NOWAIT Performance Option
Список pgsql-hackers
Jonah H. Harris wrote:
> On 2/27/07, Josh Berkus <josh@agliodbs.com> wrote:
> > You're missing my point, which is that nobody has demonstrated that there
> > is any real performance gain from this.  I see no reason to implement it
> > if there is no performance gain.
> 
> While I'll back your request for results, it seems nearly impossible
> to expect no performance gain using this.
> 
> Results never hurt though.

The results are going to be very close to fsync off for sufficiently
high values delay, and we _know_ fsync off is a performance win.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: COMMIT NOWAIT Performance Option
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: COMMIT NOWAIT Performance Option