When partitioning a large table in PostgreSQL, the table needs to be locked to prevent any updates, inserts, or deletes while the partitioning operation is in progress. This can result in a long-running lock, which … Continue reading How to partition a large table in PostgreSQL without a long-running lock?