Re: Autovacuum of independent tables

Поиск
Список
Период
Сортировка
От Michael Holzman
Тема Re: Autovacuum of independent tables
Дата
Msg-id CAPNViJrFNA8xiEgFeDoZ1GVKndx-MQXsES0Lg2hzrkNohzfJSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum of independent tables  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Autovacuum of independent tables  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general
Дерево обсуждения

On Tue, Sep 8, 2020 at 10:46 AM Pavel Stehule wrote:

autovacuum does cleaning of changes related to finished transactions. It does nothing if possible dead tuples are assigned to open transactions.

This is the point.
Autovacuum does not clean dead tuples of closed transactions in tableB while there is an open transaction on tableA.
But the tables have nothing in common. They are handled by separate applications and there are no transactions that touch both tables simultaneously.
Why does autovacuum create an artificial dependency on the tables?

--
Regards,
    Michael Holzman
 

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Autovacuum of independent tables
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Autovacuum of independent tables