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.
I am Tony Drake - Professional web developer, geek, and Mario Kart connoisseur. This site is where I put my ramblings and talk about my interests.