Re: Recalculating OldestXmin in a long-running vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Recalculating OldestXmin in a long-running vacuum
Дата
Msg-id 21171.1168965086@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Recalculating OldestXmin in a long-running vacuum  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: Recalculating OldestXmin in a long-running vacuum  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> It seems to me that we could easily reclaim a bit more dead tuples in a
> vacuum by recalculating the OldestXmin every now and then.

Doesn't this break relfrozenxid maintenance?  In any case I'd like to
see some evidence of significant real-world benefit before adding such
a conceptual wart ...

The procarray.c change scares me as well; I'm pretty sure the original
coding was intentional.

            regards, tom lane

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: scrollable cursor sup. for SPI
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Recalculating OldestXmin in a long-running vacuum