DigiNews

Tech Watch by Johan Denoyer

← Back to articles

Add CONCURRENTLY option to REPACK

Quality: 9/10 Relevance: 9/10

Summary

PostgreSQL commit adds a CONCURRENTLY option to REPACK to enable non-locking repacks by using an MVCC snapshot and a background process to capture concurrent data changes. It notes constraints such as scarce replication slots, a system-wide limit of one REPACK at a time, and potential deadlocks during the final swap, with future improvements planned.

🚀 Service construit par Johan Denoyer