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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Дата
Msg-id 54255CE3.9090701@vmware.com
обсуждение исходный текст
Ответ на Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}  (Andres Freund <andres@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Следующее
От: Oskari Saarenmaa
Дата:
Сообщение: Re: Inefficient barriers on solaris with sun cc