All Posts

Using UUIDv7 with Rails without PostgreSQL 18

Published: November 09, 2025
UUIDv7 was added to PostgreSQL 18 to support time-based UUIDs, but you don't have to upgrade to take advantage of them now.

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.