Re: synchronous commit vs. hint bits

Поиск
Список
Период
Сортировка
От yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Тема Re: synchronous commit vs. hint bits
Дата
Msg-id 20111130063729.C15EE14A223@mail.netbsd.org
обсуждение исходный текст
Ответ на Re: synchronous commit vs. hint bits  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: synchronous commit vs. hint bits
Список pgsql-hackers
hi,

> On Tue, Nov 29, 2011 at 1:42 AM, YAMAMOTO Takashi
> <yamt@mwd.biglobe.ne.jp> wrote:
>>> On Mon, Nov 7, 2011 at 5:26 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>>>
>>>>> 5. Make the WAL writer more responsive, maybe using latches, so that
>>>>> it doesn't take as long for the commit record to make it out to disk.
>>>>
>>>> I'm working on this already as part of the update for power
>>>> reduction/group commit/replication performance.
>>>
>>> I extracted this from my current patch for you to test.
>>
>> is it expected to produce more frequent fsync?
> 
> Yes, I would expect that.  What kind of increase are you seeing?  Is
> it causing a problem for you, or are you just making an observation?

i was curious because my application uses async commits mainly to
avoid frequent fsync.  i have no numbers right now.

YAMAMOTO Takashi

> 
> -- 
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Word-smithing doc changes
Следующее
От: jesper@krogh.cc
Дата:
Сообщение: GIN internal query-plan alternatives.