Hi! > 16 июля 2018 г., в 22:58, Andrey Klychkov <aaklych...@mail.ru> написал(а): > Dear hackers! > > I have an idea to facilitate work with index rebuilding. > .... > "ALTER INDEX ... RENAME CONCURRENTLY TO ..."
The idea seems useful. I'm not an expert in CIC, but your post do not cover one very important topic. When we use CREATE INDEX CONCURRENTLY we pay for less intrusive lock by scanning data twice. What is the price of RENAME CONCURRENTLY? Should this mode be default? Best regards, Andrey Borodin.
