Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Date
Msg-id 54255CE3.9090701@vmware.com
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 09/26/2014 03:30 PM, Andres Freund wrote:
> On 2014-09-26 15:24:21 +0300, Heikki Linnakangas wrote:
>> I don't know what you mean by "in the head of AM", but IMO it would be far
>> better if we can implement this outside the index AMs. Then it will work
>> with any index AM.
>
> Also, it's the only chance to make this ever work across partitions.

How so? Assuming there's no overlap in the partitions, you could lock 
the page in the index of the partition you're inserting to, just like 
you would insert the promise tuple to the right partition.

- Heikki




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Next
From: Oskari Saarenmaa
Date:
Subject: Re: Inefficient barriers on solaris with sun cc