When do vacuumed pages/tuples become available for reuse?

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: When do vacuumed pages/tuples become available for reuse?
Date: 2019-04-11 07:19:43
Message-ID: 9cd73fcb-511d-ede9-6789-209b7d4eb193@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If an autovacuum job on a huge table runs for 5-6 hours, do its freed
pages/tuples become available for reuse immediately when they are marked
as free, or only at the end of the multi-hour vacuum operation?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 김준형 2019-04-11 08:45:09 Re: Fwd: Postgresql with nextcloud in Windows Server
Previous Message Ron 2019-04-11 07:01:50 Re: Recommendation to run vacuum FULL in parallel