top | item 42028098 (no title) VMtest | 1 year 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 discuss order hn newest t-writescode|1 year 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...
t-writescode|1 year 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...
t-writescode|1 year ago
https://www.postgresql.org/docs/current/sql-createindex.html...