Hi!
> 16 июля 2018 г., в 22:58, Andrey Klychkov <aaklychkov@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
CREATEINDEX 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.