Re: Adding REPACK [concurrently]

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Antonin Houska <ah(at)cybertec(dot)at>
Cc: Mihail Nikalayeu <mihailnikalayeu(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-02-06 15:08:27
Message-ID: 202602061452.uzu7cksrgzf4@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here's a v33, where pg_repackdb has been removed, per multiple
discussions off-list. This is not a statement that we will never have
such a tool; just that for the time being we should not let ourselves be
distracted by it. If we have time to get something done about it for
v19, then it's fine to bring it back; but I kinda doubt it. I think
getting bits done including the addition of the CONCURRENTLY option
trumps that. We can add it in v20 if we decide to; no great loss.

I didn't include Antonin's 0006 "Use multiple snapshots to copy the
data" either. It seems a bit too experimental yet. I think it would be
good to have it in v19 also, but it seems less critical than the rest.

I haven't looked at Mihail's patch downthread either.

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Los cuentos de hadas no dan al niño su primera idea sobre los monstruos.
Lo que le dan es su primera idea de la posible derrota del monstruo."
(G. K. Chesterton)

Attachment Content-Type Size
v33-0001-Add-REPACK-command.patch text/x-diff 109.3 KB
v33-0002-Refactor-index_concurrently_create_copy-for-use-.patch text/x-diff 8.7 KB
v33-0003-Move-conversion-of-a-historic-to-MVCC-snapshot-t.patch text/x-diff 5.6 KB
v33-0004-Add-CONCURRENTLY-option-to-REPACK-command.patch text/x-diff 146.0 KB
v33-0005-Use-background-worker-to-do-logical-decoding.patch text/x-diff 65.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2026-02-06 15:09:49 Re: Pasword expiration warning
Previous Message Aditya Kamath 2026-02-06 15:00:42 RE: AIX support