Re: [PERFORM] Terrible performance on wide selects

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: [PERFORM] Terrible performance on wide selects
Дата
Msg-id Pine.NEB.4.51.0301240048580.547@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: Terrible performance on wide selects  (Daniel Kalchev <daniel@digsys.bg>)
Список pgsql-hackers
On Thu, 23 Jan 2003, Daniel Kalchev wrote:

> Does this mean, that constructing tables where fixed length fields are
> 'before' variable lenght fields and 'possibly null' fields might increase
> performance?

This, I believe, is why DB2 always puts (in physical storage) all of the
fixed-length fields before the variable-length fields.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: Options for growth
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: Call for objections: put back OIDs in CREATE TABLE AS/SELECT INTO