Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum of independent tables - Mailing list pgsql-general

From Michael Holzman
Subject Re: Autovacuum of independent tables
Date
Msg-id CAPNViJrFNA8xiEgFeDoZ1GVKndx-MQXsES0Lg2hzrkNohzfJSA@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum of independent tables  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Autovacuum of independent tables
List pgsql-general
Tree view

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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Autovacuum of independent tables
Next
From: Michael Paquier
Date:
Subject: Re: Autovacuum of independent tables