Re: Autovacuum and OldestXmin

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum and OldestXmin
Дата
Msg-id 22797.1195798464@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Autovacuum and OldestXmin  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Autovacuum and OldestXmin  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> That's a killer reason, I suppose. I was really trying to uncover what
> the thinking was, so we can document it. Having VACUUM ignore it
> completely seems wrong.

What you seem to be forgetting is that VACUUM is charged with cleaning
out LP_DEAD tuples, which HOT cannot do.  And the page header fields are
set (quite properly so) with HOT's interests in mind not VACUUM's.
        regards, tom lane


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

Предыдущее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: wrong behavior using to_char() again
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] possible to create multivalued index from xpath() results in 8.3?