| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | Peter Geoghegan <pg(at)heroku(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>, Craig Ringer <craig(at)2ndquadrant(dot)com> |
| Subject: | Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} |
| Date: | 2014-09-26 12:32:35 |
| Message-ID: | 54255CE3.9090701@vmware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oskari Saarenmaa | 2014-09-26 12:36:02 | Re: Inefficient barriers on solaris with sun cc |
| Previous Message | Andres Freund | 2014-09-26 12:30:11 | Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} |