Hi
út 8. 9. 2020 v 9:32 odesílatel Michael Holzman <michaelholzman(at)gmail(dot)com>
napsal:
> 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?
>
autovacuum does cleaning of changes related to finished transactions. It
does nothing if possible dead tuples are assigned to open transactions.
Regards
Pavel
>
> --
> Regards,
> Michael Holzman
>