🗄️ Databases Tutorials

Free Databases tutorials and step-by-step guides for developers.

Add an Index to a Large Postgres Table Without Locking It

CREATE INDEX locks writes. CREATE INDEX CONCURRENTLY does not. Here is how to use it, monitor it, and recover when it fails halfway.