Autovacuum of independent tables

From: Michael Holzman <michaelholzman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Autovacuum of independent tables
Date: 2020-09-08 07:32:36
Message-ID: CAPNViJrQFge6EW_dvwaLB8pjRq4K51vnvcYBPNb8SuTW88MrBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have two applications A and B. A runs SELECT statements only and only on
tableA. B actively updates tableB, A never looks into tableB. B has nothing
to do with tableA.

Still, if A is inside a long running transaction, autovacuum does not
handle tableB. Why is it so?

--
Regards,
Michael Holzman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2020-09-08 07:45:53 Re: Autovacuum of independent tables
Previous Message Junfeng Yang 2020-09-08 01:53:26 回复: Is it possible to set end-of-data marker for COPY statement.