Long running backup preventing auto vacuum

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Long running backup preventing auto vacuum
Date: 2022-06-30 09:23:43
Message-ID: CAFpL5VwzNPONgEcpFYSNgpBX1-SQ4RFoxNJGxC5iNXKRkHxk-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

PostgreSQL version - 11.7

We are using wal-g for backup/restore. We had a duration of high WAL
generation due to application usage due to which archive backup was
delayed.

Backup was started through cron schedule and it didn't complete because it
waits for the last WAL to be archived. Now, I know that long running
transactions will prevent vacuuming of dead tuples but in this case we were
able to run manual vacuums successfully but auto-vacuum never starts.

As soon as we terminated the long running backup session, the auto-vacuum
started kicking in.

Wanted to understand why a backup operation is blocking the auto-vacuum?

Wal-g uses non-exclusive backups and waits for the last wal to be archived.

Thanks,
Nikhil

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrey Borodin 2022-06-30 11:48:06 Re: Long running backup preventing auto vacuum
Previous Message christine sarsonas 2022-06-29 08:15:51 Incremental Backup via WAL archive