Partitioning a Large PostgreSQL Table with Minimal Downtime Using Logical Replication
Background (partition migration with logical replication) Large PostgreSQL tables eventually run into performance problems. As rows accumulate, queries slow down, indexes bloat, and retention policies become harder to enforce. In one of our projects, we had a table called analytics.user_activity that logged every user action across an application. It had grown to hundreds of millions…