Re: Terrible performance on wide selects

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Terrible performance on wide selects
Дата
Msg-id 25725.1043281804@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Terrible performance on wide selects  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-hackers
"Dann Corbit" <DCorbit@connx.com> writes:
> For the disk case, why not have the start of the record contain an array
> of offsets to the start of the data for each column?  It would only be
> necessary to have a list for variable fields.

No, you'd need an entry for *every* column (or at least, every one to
the right of the first variable-width column or NULL).  That's a lot of
overhead, especially in comparison to datatypes like bool or int4 ...

            regards, tom lane

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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Terrible performance on wide selects
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Re: Terrible performance on wide selects