Postgres Pro
Downloads
Home   >   mailing lists

Autovacuum of independent tables - Mailing list pgsql-general

From Michael Holzman
Subject Autovacuum of independent tables
Date
Msg-id CAPNViJrQFge6EW_dvwaLB8pjRq4K51vnvcYBPNb8SuTW88MrBw@mail.gmail.com
Whole thread Raw
Responses Re: Autovacuum of independent tables  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Autovacuum of independent tables  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Diego
Date:
Subject: Re: Extensión pldebugger para Postgresql 12 en Centos 7, no encontrada
Next
From: Pavel Stehule
Date:
Subject: Re: Autovacuum of independent tables