Re: gen_random_uuid key collision

Поиск
Список
Период
Сортировка
От jesusthefrog
Тема Re: gen_random_uuid key collision
Дата
Msg-id CAH_wARvV3stivD3PcXw4VCsWKn_oZo6720NLYBNJL+52cDq57Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: gen_random_uuid key collision  (Peter Geoghegan <pg@bowt.ie>)
Список 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 по дате отправления:

Предыдущее
От: Philippe Doussot
Дата:
Сообщение: update non-indexed value is slow if some non-related index/fk are enabled
Следующее
От: Richard Michael
Дата:
Сообщение: How to observe plan_cache_mode transition from custom to generic plan?