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 PostgreSQL Partition: How to Partition a Large Table Without a Long-Running Lock