Re: Correction: datatypes are not "faster"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Correction: datatypes are not "faster"
Date: 2010-09-02 22:13:39
Message-ID: 15330.1283465619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Josh Berkus 2010-09-02 22:24:40 Re: Correction: datatypes are not "faster"
Previous Message Josh Berkus 2010-09-02 22:09:15 Correction: datatypes are not "faster"