Re: INSERT ... ON CONFLICT DO UPDATE

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: INSERT ... ON CONFLICT DO UPDATE
Date: 2015-07-20 14:01:58
Message-ID: CAEzk6fdwdZvRPQY-pvCGHq_VigM7JkhwvnBa+Je4ZdOhRy8UEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 20 July 2015 at 14:33, Rafal Pietrak <rafal(at)ztk-rp(dot)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​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2015-07-20 14:02:43 Re: Lots of stuck queries after upgrade to 9.4
Previous Message Spiros Ioannou 2015-07-20 14:00:52 Re: Lots of stuck queries after upgrade to 9.4