| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, Peter Geoghegan <pg(at)bowt(dot)ie>, Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: conchuela timeouts since 2021-10-09 system upgrade |
| Date: | 2021-10-27 11:08:51 |
| Message-ID: | D6202938-81AD-42DD-BDC6-D4221189251C@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> 26 окт. 2021 г., в 22:41, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал(а):
>
> We can get around that though, by using pg_try_advisory_lock and not
> proceeding if it fails. The attached POC does this for the 002 test;
> it looks like the same thing could be done to 003.
That's a neat idea. PFA patch with copy of this changes to 003.
Also I've added a script to stress not only CREATE INDEX CONCURRENTLY, but also REINDEX CONCURRENTLY.
Because it was easy and checks slightly more code paths.
I do not observe failures on Dragonfly 6.0 with the patch, but I didn't run for a long yet time.
Best regards, Andrey Borodin.
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-CIC-test-without-background-pgbench.patch | application/octet-stream | 5.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2021-10-27 23:11:12 | BUG #17249: Bug in .pgpass search and/or documentation thereof, Ubuntu 13.4-4 |
| Previous Message | Semab Tariq | 2021-10-27 09:38:34 | Re: BUG #17248: Installation fails... |