6 ms·
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
by VMtest 2y 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
- t-writescode 2y agoIn 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#SQL-CREATEINDEX-CONCURRENTLY https://www.postgresql.org/docs/current/sql-createindex.html...