Re: Adding REPACK [concurrently] - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Adding REPACK [concurrently]
Date
Msg-id 202603311523.iqhng5ljkzpq@alvherre.pgsql
Whole thread Raw
In response to Re: Adding REPACK [concurrently]  (Antonin Houska <ah@cybertec.at>)
Responses Re: Adding REPACK [concurrently]
List pgsql-hackers
On 2026-Mar-31, Antonin Houska wrote:

> Amit Kapila <amit.kapila16@gmail.com> wrote:
> 
> > On Fri, Mar 27, 2026 at 10:31 PM Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:

> > BTW, are we intending to commit this patch series for PG19?
> 
> Yes, that's the current plan.

Yes -- though as I said upthread, this particular patch in the series is
the one I'm the least sure about.  Also, the structure of the patches to
commit is not like the ones posted here or previously.  I'll post a
committable one later on; see below for a breakdown.  For now, I brought
the addition of options to table AM methods from [1] into this series,
in what I think is pretty much final form (0002); and I added a 0004
patch that's code review for the big patch, which I'll squash for the
next version, and is posted here separately just so that it's easy to
see.

My intention as to patches for final commit is:

- 0001 "Make index_concurrently_create_copy more general" same as here.
- 0002 "give options bitmask to table_delete/table_update" same as here,
       with a real commit message.
- 0003 Rename cluster.c/h to repack.c/h (similar to 0006 here); no
       essential change in contents.
- 0004 "Add CONCURRENTLY option to REPACK command".  Squash of 0003,
       0004, 0005 and 0007.
- 0005 "Error out any process that would block at REPACK", same as here.

I'm unsure on whether 0009 would be pushed or not.


[1] https://postgr.es/m/202603171606.kf6pmhscqbqz@alvherre.pgsql
 
-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/

Attachment

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion?
Next
From: Nathan Bossart
Date:
Subject: Re: Add pg_stat_autovacuum_priority