Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A888D632898 for ; Thu, 2 Sep 2010 19:14:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 80762-05 for ; Thu, 2 Sep 2010 22:14:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 05040632536 for ; Thu, 2 Sep 2010 19:13:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o82MDeP9015331; Thu, 2 Sep 2010 18:13:40 -0400 (EDT) To: Josh Berkus cc: pgsql-docs@postgresql.org Subject: Re: Correction: datatypes are not "faster" In-reply-to: <4C80208B.4060908@agliodbs.com> References: <4C80208B.4060908@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Thu, 02 Sep 2010 15:09:15 -0700" Date: Thu, 02 Sep 2010 18:13:39 -0400 Message-ID: <15330.1283465619@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/29 X-Sequence-Number: 6019 Josh Berkus 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