Horton

Reserve replication slots specifically for REPACK

Álvaro Herrera <alvherre@kurilemu.de>

View on postgr.es
Commit: e76d8c749c3152657711ed733f0aea61c0e36a91
Author: Álvaro Herrera <alvherre@kurilemu.de>
Date: 2026-04-07T14:55:29Z
Releases: 19 (unreleased) 
Reserve replication slots specifically for REPACK

Add a new GUC max_repack_replication_slots, which lets the user reserve
some additional replication slots for concurrent repack (and only
concurrent repack).  With this, the user doesn't have to worry about
changing the max_replication_slots in order to cater for use of
concurrent repack.

(We still use the same pool of bgworkers though, but that's less
commonly a problem than slots.)

Author: Álvaro Herrera <alvherre@kurilemu.de>
Reviewed-by: Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Discussion: https://postgr.es/m/202604012148.nnnmyxxrr6nh@alvherre.pgsql

Files

PathChange+/−
doc/src/sgml/config.sgml modified +15 −0
doc/src/sgml/ref/repack.sgml modified +3 −3
src/backend/commands/repack_worker.c modified +4 −3
src/backend/replication/logical/launcher.c modified +1 −1
src/backend/replication/logical/logical.c modified +5 −3
src/backend/replication/logical/logicalfuncs.c modified +1 −1
src/backend/replication/logical/slotsync.c modified +3 −2
src/backend/replication/slot.c modified +59 −33
src/backend/replication/slotfuncs.c modified +10 −9
src/backend/replication/walsender.c modified +5 −4
src/backend/utils/misc/guc_parameters.dat modified +8 −0
src/backend/utils/misc/postgresql.conf.sample modified +2 −0
src/include/replication/logical.h modified +2 −1
src/include/replication/slot.h modified +3 −2

Discussion