Always remember to check for long-running uncommitted transactions before running
CREATE INDEX CONCURRENTLY in Postgres. It avoids table write locks, but it still waits for existing transactions to finish before completing its second table scan, which can quietly queue up incoming locks behind it.commit 3cd5c4c