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
Michael Holzman
