Re: Control.sh command that schedules index rebuild in the maintenance mode

2022-05-31 Thread Данилов Семён
Hello, Nikolay! Online rebuild causes unpredictable behaviour of the indexed SQL queries. For example, if a query plan requires an index scan, we will instead resort to the full scan which is unacceptable for some users. So sometimes it’s better to shutdown the node than mess up the application

Re: Control.sh command that schedules index rebuild in the maintenance mode

2022-05-31 Thread Николай Ижиков
Hello, Семен. Why index rebuild should be done in maintenance mode? > 31 мая 2022 г., в 18:24, Данилов Семён написал(а): > > Hello, igniters! > > I want to propose a new control.sh cache sub-command that schedules a rebuild > of cache indexes in the maintenance mode. > We already have a forc