Hacker News new | ask | show | jobs
by VMtest 588 days ago
creating indexes will lock the tables if not mistaken, the problem about database is that many of us just don't study enough to make sense out of it
1 comments

In PostgreSQL you can create indexes concurrently, so the database doesn't have to go down to create a new index:

https://www.postgresql.org/docs/current/sql-createindex.html...