doc: Update REPACK-related table rewrite documentation Adding REPACK introduced table-rewrite behavior that overlaps with VACUUM FULL and CLUSTER, but some documentation still mentioned only one of these commands or described the progress and locking behavior imprecisely.
Clarify that table-rewriting operations, including REPACK, can change CTIDs. Also describe VACUUM FULL, CLUSTER, and REPACK consistently as table-rewriting operations for disk-space recovery where appropriate, document the pg_stat_progress_repack and compatibility pg_stat_progress_cluster views consistently, and clarify the ACCESS EXCLUSIVE locking behavior of REPACK, including CONCURRENTLY. Backpatch to v19, where REPACK was introduced. Author: Marcos Pegoraro <[email protected]> Author: Fujii Masao <[email protected]> Discussion: https://postgr.es/m/CAB-JLwaLcHyf=onlnbsjebdd57wjwppk5t7igfjvaqphjtz...@mail.gmail.com Backpatch-through: 19 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/872b20aa5649f9b90781961cbc404409783dab2b Modified Files -------------- doc/src/sgml/ddl.sgml | 4 +++- doc/src/sgml/maintenance.sgml | 45 ++++++++++++++++++++++++++----------------- doc/src/sgml/monitoring.sgml | 24 +++++++++++++---------- doc/src/sgml/mvcc.sgml | 12 ++++++++---- 4 files changed, 52 insertions(+), 33 deletions(-)
