| From: | jesusthefrog <jesusthefrog(at)gmail(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: gen_random_uuid key collision |
| Date: | 2021-09-03 21:35:45 |
| Message-ID: | CAH_wARvV3stivD3PcXw4VCsWKn_oZo6720NLYBNJL+52cDq57Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
> Note that the parent variant takes a disruptive lock that will block
> write DML. You might prefer to just use the first query if this is
> running in a production environment.
>
Fortunately this has only been observed on the dev instance.
This morning I tried just dropping and recreating the index, so I'll see if
that has solved it. If it has, then the root cause may remain a mystery; if
not, I'll try amcheck.
--
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT d- s+ a- C++++ L+++ S++ B+ P++>++++ E++ W+++
N o? K- !w++++ O- M- V? PS++ PE- Y+ PGP t+ 5+++
X R+ tv b+++ DI++ D++ G+ e-- h- r++ y
------END GEEK CODE BLOCK------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Emmenlauer | 2021-09-05 08:29:24 | Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0 |
| Previous Message | Philippe Doussot | 2021-09-03 15:27:47 | update non-indexed value is slow if some non-related index/fk are enabled |