Re: mysterious nbtree.c comment

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: mysterious nbtree.c comment
Дата
Msg-id 7312.1151967546@sss.pgh.pa.us
обсуждение исходный текст
Ответ на mysterious nbtree.c comment  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> I don't see how the lack of deletions is relevant to needing vacuum-cycle-ID.
> AFAICT there's still a risk that someone will come along and do a page split
> underneath this scan and if the page is to the left of the scan it will be
> missed.

Well, if there are active insertions or deletions happening in parallel
with the scan, the tuple count is going to be at best approximate
anyway, no?  So there's no need to be tense about ensuring we visit
every single index tuple.  We do want to hit all the pages so we can
clean up any recyclable pages, but that's not a problem.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: buildfarm stats
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Transaction and table partitioning