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
|
Список | 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 по дате отправления: