Adding an index to a partitioned table and its children in PostgreSQL and Rails

Published: March 30, 2022
Postgres 10+ made partitioning tables much easier, however adding an index to a table with many partitions and data in them already is not straightforward if you want to avoid long table locking.