Re: why there is not VACUUM FULL CONCURRENTLY?

From: Antonin Houska <ah(at)cybertec(dot)at>
To: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Michael Banck <mbanck(at)gmx(dot)net>, Junwang Zhao <zhjwpku(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: why there is not VACUUM FULL CONCURRENTLY?
Date: 2025-02-26 08:48:08
Message-ID: 127361.1740559688@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:

> You mentioned fillfactor only on cluster notes, would be good to mention it
> on refsynopsisdiv, I think.

ok, I've added a note to the first paragraph.

Attached here is the REPACK command as well as the patch set that adds the
CONCURRENTLY option. The new symbols have been renamed so they resemble REPACK
rather than CLUSTER.

Please note that 0008 is a new part which makes the setting wal_leve=logical
unnecessary.

--
Antonin Houska
Web: https://www.cybertec-postgresql.com

Attachment Content-Type Size
v08-0001-Add-REPACK-command.patch text/x-diff 89.7 KB
v08-0002-Move-progress-related-fields-from-PgBackendStatus-to.patch text/x-diff 7.8 KB
v08-0003-Move-conversion-of-a-historic-to-MVCC-snapshot-to-a-.patch text/x-diff 5.4 KB
v08-0004-Add-CONCURRENTLY-option-to-REPACK-command.patch text/plain 168.4 KB
v08-0005-Preserve-visibility-information-of-the-concurrent-da.patch text/x-diff 39.6 KB
v08-0006-Add-regression-tests.patch text/x-diff 10.6 KB
v08-0007-Introduce-repack_max_xlock_time-configuration-variab.patch text/x-diff 20.3 KB
v08-0008-Enable-logical-decoding-transiently-only-for-REPACK-.patch text/x-diff 24.2 KB
v08-0009-Call-logical_rewrite_heap_tuple-when-applying-concur.patch text/x-diff 26.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jakub Wartak 2025-02-26 08:48:41 Re: Draft for basic NUMA observability
Previous Message Maxim Orlov 2025-02-26 08:46:45 Re: Proposal: Limitations of palloc inside checkpointer