Re: Reduce pinning in btree indexes

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Reduce pinning in btree indexes
Дата
Msg-id 87zj7z6ckc.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: Reduce pinning in btree indexes  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Ответы Re: Reduce pinning in btree indexes  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Список pgsql-hackers
>>>>> "Kyotaro" == Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> writes:
>> You might want to try running the same test, but after patching>> ExecSupportsMarkRestore to return false for index
scans.This will>> cause the planner to insert a Materialize node to handle the>> mark/restore.
 
Kyotaro> Mmm? The patch bt-nopin-v1.patch seems not contain the changeKyotaro> for ExecSupportMarkRestore and the very
simplefunction remainKyotaro> looking to return true for T_Index(Only)Scan after the patchKyotaro> applied.
 

Right. I'm suggesting you change that, in order to determine what
performance cost, if any, would result from abandoning the idea of doing
mark/restore entirely.

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Merge compact/non compact commits, make aborts dynamically sized
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Reduce pinning in btree indexes