Re: gen_random_uuid key collision - Mailing list pgsql-general

From jesusthefrog
Subject Re: gen_random_uuid key collision
Date
Msg-id CAH_wARvV3stivD3PcXw4VCsWKn_oZo6720NLYBNJL+52cDq57Q@mail.gmail.com
Whole thread Raw
In response to Re: gen_random_uuid key collision  (Peter Geoghegan <pg@bowt.ie>)
List 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------

pgsql-general by date:

Previous
From: Philippe Doussot
Date:
Subject: update non-indexed value is slow if some non-related index/fk are enabled
Next
From: Richard Michael
Date:
Subject: How to observe plan_cache_mode transition from custom to generic plan?