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"
|
| Список | 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 по дате отправления: