Y
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
t-writescode
588 days ago
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...
link
https://www.postgresql.org/docs/current/sql-createindex.html...