Re: The vacuum-ignore-vacuum patch

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: The vacuum-ignore-vacuum patch
Дата
Msg-id 200607121522.45771.peter_e@gmx.net
обсуждение исходный текст
Ответ на The vacuum-ignore-vacuum patch  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-patches
Am Dienstag, 11. Juli 2006 23:01 schrieb Alvaro Herrera:
> One exception is that we can't do that with full vacuums.  The reason is
> that full vacuum may want to run user-defined functions to be able to
> index the tuples it moves.  This isn't a problem normally, except in the
> case where the function tries to scan some other table: if we ignored
> that transaction, then another lazy vacuum might delete tuples from that
> table that we need to see.

Functions in the index expression must be immutable, so I don't think that is
a real concern.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: reply to ...
Следующее
От: "Larry Rosenman"
Дата:
Сообщение: Re: [patch 0/9] annual pgcrypto update