Search Postgresql Archives

Autovacuum of independent tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Autovacuum of independent tables
From: Michael Holzman <michaelholzman@xxxxxxxxx>
Date: Tue, 8 Sep 2020 10:32:36 +0300

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Autovacuum of independent tables
  - From: Stephen Frost
- Re: Autovacuum of independent tables
  - From: Pavel Stehule

Prev by Date: Re: Extensión pldebugger para Postgresql 12 en Centos 7, no encontrada
Next by Date: Re: Autovacuum of independent tables
Previous by thread: Re: Extensión pldebugger para Postgresql 12 en Centos 7, no encontrada
Next by thread: Re: Autovacuum of independent tables
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux