Re: Maintaining cluster order on insert

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Maintaining cluster order on insert
Дата
Msg-id 27526.1179500906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Maintaining cluster order on insert  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: Maintaining cluster order on insert  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> The beef of the patch is two new optional indexam API functions:
> amprepareinsert and amfinishinsert. amprepareinsert is called before
> inserting the heap tuple. It descends the tree and finds and pins the
> right leaf page to insert to, and returns a suggestion on where the heap
> tuple should be inserted. amfinishinsert is called after inserting the
> heap tuple to actually insert the index tuple. Documentation for these
> functions need to be added indexam.sgml, I noticed that that's not done yet.

What happens when there's more than one index?

Is there a risk of deadlock during concurrent insertions (from different
processes trying to lock the same buffers in different orders)?

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Maintaining cluster order on insert