| From: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Lock contention issues with repack |
| Date: | 2024-10-22 18:58:06 |
| Message-ID: | CAJCZkoKRi1NLZd6gKX_NYsNQx5JyfTLMaaxSo8fiXZenKkK_=w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
DEBUG: Poll returned: 1
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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2024-10-22 19:01:55 | Re: Query performance issue |
| Previous Message | Dominique Devienne | 2024-10-22 16:16:12 | Re: Regression in Postgres 17? |