← All posts
#partitioning
How to partition a 1 TB PostgreSQL table without downtime: the default-partition method
Partition a live 1 TB Postgres table without downtime: attach it as the DEFAULT partition, copy history out with Oban jobs, then swap in one short transaction.
PostgreSQL partitioning in practice: partition keys, pruning, indexes and retention
How PostgreSQL partitioning behaves in practice: choosing the key and size, checking pruning with EXPLAIN, indexes, keys, retention and the Ecto gotchas.