A Zero-Downtime Migration to Time-Partitioned Tables in Postgres

#

Check out this post from our company engineering blog, in which I describe the process of migrating our databases to time-partitioned tables with no downtime or performance degradation.

Speaking personally, this was one of the more interesting feats I've pulled off in my career thus far. While the approach was relatively straightforward, the actual application of it to production environments was often a fair bit more difficult and stressful, and so its going off without a hitch was really gratifying.