Tag: partitioning
All the articles with the tag "partitioning".
Partitioning a ledger at two levels: account group and year
LIST by account group, RANGE by year, a composite primary key and one rule nobody may forget: every query carries both keys.
Creating new partitions without locking the root table
The obvious PostgreSQL command holds an ACCESS EXCLUSIVE lock on the whole table until commit. There is a path that holds nothing that matters, and it is two commands instead of one.