Re: Correction: datatypes are not "faster"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Correction: datatypes are not "faster"
Дата
Msg-id 15330.1283465619@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Correction: datatypes are not "faster"  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Correction: datatypes are not "faster"  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-docs
Josh Berkus <josh@agliodbs.com> writes:
> "The type integer is the common choice, as it offers the best balance
> between range, storage size, and performance. The smallint type is
> generally only used if disk space is at a premium. The bigint type
> should only be used if the integer range is insufficient, because the
> latter is definitely faster."

> This paragraph leaves a *lot* to be desired from an accuracy perspective

Really?  Exactly which statements will you claim are incorrect?

I notice that your proposed rewrite omits the bit about bigint being
slower, which I can only conclude means you haven't tested on any
32-bit platforms lately.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Correction: datatypes are not "faster"
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Correction: datatypes are not "faster"