Re: why there is not VACUUM FULL CONCURRENTLY?

From: Antonin Houska <ah(at)cybertec(dot)at>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: 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-01-13 13:48:31
Message-ID: 6250.1736776111@antos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:

> On 2025-Jan-09, Antonin Houska wrote:
>
> > It seems you accidentally fixed another problem :-) I was referring to the
> > 'lockmode' argument of make_new_heap(). I can try to write a patch for that
> > but ...
> >
> > > Meanwhile the patch 0004 has some seemingly trivial conflicts. If you
> > > want to rebase, I'd appreciate that. In the meantime I'll give a look
> > > at the next two other API changes.

This is the patch series rebased on top of the commit cc811f92ba.

I haven't addressed the problem of a new command yet - for that I'd like to
see some sort of consensus, so that I do not have to do all the related
changes many times.

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

Attachment Content-Type Size
v07-0002-Move-progress-related-fields-from-PgBackendStatus-to.patch text/x-diff 6.6 KB
v07-0003-Move-conversion-of-a-historic-to-MVCC-snapshot-to-a-.patch text/x-diff 5.4 KB
v07-0004-Add-CONCURRENTLY-option-to-both-VACUUM-FULL-and-CLUS.patch text/plain 171.4 KB
v07-0005-Preserve-visibility-information-of-the-concurrent-da.patch text/x-diff 39.7 KB
v07-0006-Add-regression-tests.patch text/x-diff 10.4 KB
v07-0007-Introduce-cluster_max_xlock_time-configuration-varia.patch text/x-diff 20.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Banck 2025-01-13 13:55:48 Re: why there is not VACUUM FULL CONCURRENTLY?
Previous Message Alena Rybakina 2025-01-13 13:26:57 Re: Vacuum statistics