Tag: locks
All the articles with the tag "locks".
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.