Re: [HACKERS] Terrible performance on wide selects

Поиск
Список
Период
Сортировка
От Dann Corbit
Тема Re: [HACKERS] Terrible performance on wide selects
Дата
Msg-id D90A5A6C612A39408103E6ECDD77B8294CD864@voyager.corporate.connx.com
обсуждение исходный текст
Ответы Re: [HACKERS] Terrible performance on wide selects  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-performance
[snip]
> So (for instance) if you have 12 variable fields, you would
> store 12 integers at the start of the record.

Additionally, you could implicitly size the integers from the properties
of the column.  A varchar(255) would only need an unsigned char to store
the offset, but a varchar(80000) would require an unsigned int.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: relaxing link between explicit JOINs and execution order
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Terrible performance on wide selects