Re: Long running backup preventing auto vacuum

> 1 июля 2022 г., в 12:41, Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> написал(а):
>
> I think this tx can be safely removed
> How can I remove this? I can test whether this is the problem

I'v thought more about it and don't see any sense in removing tx from WAL-G code.
The very same virtual transaction would be started implicitly by "select pg_stop_backup()" SQL call. It will obtain a snapshot holding global xmin.

I don't think we can make anything here on WAL-G side, this is how Postgres backup API works.

But I'd recommend focusing on eliminating lag of the WAL archivation. Why did you have so many unarchived WALs? Maybe it worth some monitoring etc.

Thanks!

Best regards, Andrey Borodin.