LOG: Command finished in worker 1: CREATE UNIQUE INDEX index_3199790649 ON repack.table_5832724 USING btree (id) DEBUG: ---- swap ---- DEBUG: query failed: ERROR: canceling statement due to statement timeout DETAIL: query was: LOCK TABLE offer.market IN ACCESS EXCLUSIVE MODE DEBUG: query failed: ERROR: canceling statement due to statement timeout DETAIL: query was: LOCK TABLE offer.market IN ACCESS EXCLUSIVE MODE
While running pg_repack i was facing this issue as concurrent selects and updates on tables being repacked .However raised the same to pg_repack channel . No issues with low traffic on db How to resolve this issue even on moderate db workload ?
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.