Re: [PATCH] Microvacuum for gist.

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: [PATCH] Microvacuum for gist.
Дата
Msg-id 55E98A60.3000805@sigaev.ru
обсуждение исходный текст
Ответ на Re: [PATCH] Microvacuum for gist.  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Ответы Re: [PATCH] Microvacuum for gist.  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Список pgsql-hackers
Some notices

1 gistvacuumpage():    OffsetNumber deletable[MaxOffsetNumber];  Seems, MaxOffsetNumber is too much,
MaxIndexTuplesPerPageis enough
 

2 Loop in gistkillitems() for searching heap pointer. It seems to me that
it could be a performance problem. To fix it, it's needed to remember index 
tuple's offset number somewhere near GISTScanOpaqueData->killedItems. And
gistkillitems() will loop over offsets and compare heap pointer from killedItems 
and index tuple, if they doesn't match then just skip this index tuple.

3 Connected with previous, could you show some performance tests?


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 



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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Truncating/vacuuming relations on full tablespaces
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Testing WAL replay by comparing before and after images again