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 ?