Re: INSERT ... ON CONFLICT DO UPDATE

Поиск
Список
Период
Сортировка
От Geoff Winkless
Тема Re: INSERT ... ON CONFLICT DO UPDATE
Дата
Msg-id CAEzk6fdwdZvRPQY-pvCGHq_VigM7JkhwvnBa+Je4ZdOhRy8UEw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: INSERT ... ON CONFLICT DO UPDATE  (Rafal Pietrak <rafal@ztk-rp.eu>)
Ответы Re: INSERT ... ON CONFLICT DO UPDATE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: INSERT ... ON CONFLICT DO UPDATE  (Jeff Janes <jeff.janes@gmail.com>)
Re: INSERT ... ON CONFLICT DO UPDATE  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
On 20 July 2015 at 14:33, Rafal Pietrak <rafal@ztk-rp.eu> wrote:
If I'm not mistaken, the conclusions from posts in this thread are:

3. there are methods (like cryptographic "random" sequence), which
guarantee no conflicts. So one should resort to that.


Some web research suggests that random sequences are not great for indexes because of the resultant "keyspace fragmentation". I'm assuming that means a low number of nodes in the btree leafs, so an increase in memory usage for the index?

Just a thought.

Geoff​

В списке pgsql-general по дате отправления:

Предыдущее
От: Spiros Ioannou
Дата:
Сообщение: Re: Lots of stuck queries after upgrade to 9.4
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Lots of stuck queries after upgrade to 9.4