Post

CREATE INDEX CONCURRENTLY waits for REPEATABLE READ transactions even if they never touched the table. On PostgreSQL 18.6 ours sat in 'waiting for old snapshots' until an idle transaction on another table committed. READ COMMITTED didn't hold it up.