Re: Allow to specify #columns in heap/index_form_tuple

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Allow to specify #columns in heap/index_form_tuple
Дата
Msg-id 10913.1490982292@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Allow to specify #columns in heap/index_form_tuple  (Andres Freund <andres@anarazel.de>)
Ответы Re: Allow to specify #columns in heap/index_form_tuple  (Robert Haas <robertmhaas@gmail.com>)
Re: Allow to specify #columns in heap/index_form_tuple  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> The covering indexes patch [1] really needs a version of
> heap_form_tuple/index_form_tuple that allows to specify the number of
> columns in the to-be generated tuple.

I was thinking about that this morning, and wondering why exactly it
would need such a thing.  Certainly we're not going to store such a
truncated tuple in the index, so I assume that the purpose here is
just to pass around the tuple internally for some reason.  What's wrong
with just generating the full tuple, perhaps with nulls for the extra
columns if you're concerned about memory space?

> Previously the faster expression
> evaluation stuff could also have benefited form the same for both
> forming and deforming tuples.

Um, I didn't notice anyplace where that would have helped, certainly
not on the "form tuple" side.  Tuples that don't meet their own tupdesc
don't seem to have wide application to me.
        regards, tom lane



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

Предыдущее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: WIP: Covering + unique indexes.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Patch: Write Amplification Reduction Method (WARM)