3 ms·
I'm pretty sure it's just because it allows you to retry the index creation using REINDEX INDEX CONCURRENTLY, which allows you to avoid the exclusive lock creat
by AmericanChopper 2y ago
I'm pretty sure it's just because it allows you to retry the index creation using REINDEX INDEX CONCURRENTLY, which allows you to avoid the exclusive lock created by DROP INDEX, because you can't always DROP INDEX CONCURRENTLY
https://www.postgresql.org/docs/current/sql-dropindex.html https://www.postgresql.org/docs/current/sql-dropindex.html