3 ms·
Yes, though it can be less than easy for constraint indexes or FK indexes. REINDEX CONCURRENTLY is basically a shortcut for hand-rolling that reliably with less
by masklinn 8y ago
Yes, though it can be less than easy for constraint indexes or FK indexes. REINDEX CONCURRENTLY is basically a shortcut for hand-rolling that reliably with less exclusive locking: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5dc92b844e680c54a7ecd68de0ba53c949c3d605 https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit...