3 ms·
Author here! This was also published here: https://medium.com/p/20d3749ed680 https://medium.com/p/20d3749ed680, and I’ve updated it there at various times (tho
by jtc331 5y ago
Author here!
This was also published here: https://medium.com/p/20d3749ed680 https://medium.com/p/20d3749ed680, and I’ve updated it there at various times (though I’ll admit it doesn’t have the new features in PG13-14 yet) but had forgotten about the Gist version with those updates.
- MaxGabriel 5y agoIs there any notable 13/14 stuff worth mentioning?
- jtc331 5y agoI don't see anything relevant in the PG13 release notes, but in the release notes for 14 there are these items: - "Allow partitions to be detached in a non-blocking manner. The syntax is ALTER TABLE ... DETACH PARTITION ... CONCURRENTLY, and FINALIZE." I didn't cover partitioning in the guide, but this is a real improvement to DDL with partitions. - "Allow index commands using CONCURRENTLY to avoid waiting for the completion of other operations using CONCURRENTLY." This doesn't add new lower-lock level DDL, but it does improve the speed of existing such DDL. - "Allow vacuum to be more aggressive in removing dead rows during minimal-locking index operations. Specifically, CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY no longer limit the dead row removal of other relations." Similarly this doesn't add new lower-lock level DDL, but it does improve the safety of existing such DDL by eliminating a case where concurrent index creation could result in performance degradation of the system as a whole.