3 ms·
> it has to lock the table which can cause issues in high traffic databases In my case, I'm okay with a seconds-long lock while an index is dropped. An hours-l
by paulddraper 7y ago
> it has to lock the table which can cause issues in high traffic databases
In my case, I'm okay with a seconds-long lock while an index is dropped. An hours-long lock while an index is created is the real show stopper.
> But this is mostly a moot point since 12 has REINDEX CONCURRENTLY.
Fantastic.