Horton

Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}

Heikki Linnakangas <hlinnakangas@vmware.com>

View thread View on postgr.es
From: Heikki Linnakangas <hlinnakangas@vmware.com>
To: Andres Freund <andres@2ndquadrant.com>
Cc: Peter Geoghegan <pg@heroku.com>, Simon Riggs <simon@2ndquadrant.com>, "Pg Hackers" <pgsql-hackers@postgresql.org>, Craig Ringer <craig@2ndquadrant.com>
Date: 2014-09-26T12:32:35Z
Lists: 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

Commits

  1. Change the way we mark tuples as frozen.

  2. Add documentation for data-modifying statements in WITH clauses.