agora inbox for pgsql-committers@postgresql.orghelp / color / mirror / Atom feed
pgsql: Fail REPACK in presence of !indisready indexes 2+ messages / 1 participants [nested] [flat]
* pgsql: Fail REPACK in presence of !indisready indexes @ 2026-09-13 12:20 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2026-09-13 12:20 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fail REPACK in presence of !indisready indexes Like VACUUM FULL, non-concurrent REPACK would try to rebuild such indexes, which can sometimes succeed. Concurrent REPACK would however fail. The inconsistency is not good, so make them both throw an error quickly to force the user to make a decision on those indexes (most likely, drop them). Author: Álvaro Herrera <alvherre@kurilemu.de> Reported-by: Zsolt Parragi <zsolt.parragi@percona.com> Suggested-by: Kyotaro Horiguchi <horikyota.ntt@gmail.com> Discussion: https://postgr.es/m/CAN4CZFO5A3YE0Dd-bn7eKrB20pECO3=U0wKg1z2rO=DxgWJJHQ@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/0c5d6269614e107d1d2d669f82f63f7e232b30c9 Modified Files -------------- contrib/test_decoding/expected/repack.out | 16 +++++++ contrib/test_decoding/sql/repack.sql | 8 ++++ src/backend/commands/repack.c | 71 +++++++++++++++++++++++++++++++ 3 files changed, 95 insertions(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fail REPACK in presence of !indisready indexes @ 2026-09-13 12:20 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2026-09-13 12:20 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fail REPACK in presence of !indisready indexes Like VACUUM FULL, non-concurrent REPACK would try to rebuild such indexes, which can sometimes succeed. Concurrent REPACK would however fail. The inconsistency is not good, so make them both throw an error quickly to force the user to make a decision on those indexes (most likely, drop them). Author: Álvaro Herrera <alvherre@kurilemu.de> Reported-by: Zsolt Parragi <zsolt.parragi@percona.com> Suggested-by: Kyotaro Horiguchi <horikyota.ntt@gmail.com> Discussion: https://postgr.es/m/CAN4CZFO5A3YE0Dd-bn7eKrB20pECO3=U0wKg1z2rO=DxgWJJHQ@mail.gmail.com Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e14a2354d9f7e44b0ffcaeaf187aa475e3e7d11b Modified Files -------------- contrib/test_decoding/expected/repack.out | 16 +++++++ contrib/test_decoding/sql/repack.sql | 8 ++++ src/backend/commands/repack.c | 71 +++++++++++++++++++++++++++++++ 3 files changed, 95 insertions(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-09-13 12:20 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-09-13 12:20 pgsql: Fail REPACK in presence of !indisready indexes Álvaro Herrera <alvherre@kurilemu.de> 2026-09-13 12:20 pgsql: Fail REPACK in presence of !indisready indexes Álvaro Herrera <alvherre@kurilemu.de>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox