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

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

2022-05-31 Thread Данилов Семён
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 force rebuild command but sometimes (for example, under load) user may want to first stop the node and then rebuild indexes. For this scenar