Re: Adding REPACK [concurrently]

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Antonin Houska <ah(at)cybertec(dot)at>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>, Srinath Reddy Sadipiralla <srinath2133(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Treat <rob(at)xzilla(dot)net>
Subject: Re: Adding REPACK [concurrently]
Date: 2026-03-31 19:41:53
Message-ID: 202603311934.ftqj7ytm362y@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Mar-31, Alvaro Herrera wrote:

> 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.

Here it is with that structure. The first three should be pretty much
in final form (0003 needs a commit message), but I still want to make
some more cosmetic adjustments to 0004.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
Thou shalt check the array bounds of all strings (indeed, all arrays), for
surely where thou typest "foo" someone someday shall type
"supercalifragilisticexpialidocious" (5th Commandment for C programmers)

Attachment Content-Type Size
v48-0001-Make-index_concurrently_create_copy-more-general.patch text/x-diff 9.4 KB
v48-0002-Give-options-parameter-to-table_delete-table_upd.patch text/x-diff 10.6 KB
v48-0003-Rename-cluster.c-h-repack.c-h.patch text/x-diff 7.8 KB
v48-0004-Add-CONCURRENTLY-option-to-REPACK-command.patch text/x-diff 175.8 KB
v48-0005-Fix-a-few-problems-in-index-build-progress-repor.patch text/x-diff 7.4 KB
v48-0006-Error-out-any-process-that-would-block-at-REPACK.patch text/x-diff 12.6 KB
v48-0007-Teach-snapshot-builder-to-skip-transactions-runn.patch text/x-diff 18.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2026-03-31 19:42:54 Re: pg_get__*_ddl consolidation
Previous Message Masahiko Sawada 2026-03-31 19:40:14 Re: Initial COPY of Logical Replication is too slow