Re: PS display and standby query conflict

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: PS display and standby query conflict
Дата
Msg-id AANLkTindMj7ANG66sh586t8HM0_ddM+g83FxPOUTqMWb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PS display and standby query conflict  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: PS display and standby query conflict  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Sat, Dec 11, 2010 at 11:28 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> This problem happens because ResolveRecoveryConflictWithVirtualXIDs
>> resets PS display for each read-only transactions that recovery
>> waits for. Why do we need to reset that each time even though
>> the conflict has not been resolved yet? The attached patch
>> suppresses such a needless reset. Comments?
>
> The reset occurs at most each 500ms, so not much problem there.
>
> But if it annoys you, it seems OK to change it. Don't see a reason to backpatch though?

I think that It's worth backpatch to prevent users who observe the
occurrence of the query conflicts carefully for testing 9.0 from
getting confusing.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED
Следующее
От: Nathan Boley
Дата:
Сообщение: Re: proposal : cross-column stats