Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8EEE863241D for ; Thu, 2 Sep 2010 19:56:59 -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 81037-09 for ; Thu, 2 Sep 2010 22:56:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 4EF74632484 for ; Thu, 2 Sep 2010 19:56:52 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 3E4C9348013; Thu, 2 Sep 2010 15:56:50 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id yk7vBd-L4Z5e; Thu, 2 Sep 2010 15:56:47 -0700 (PDT) Received: from [192.168.1.132] (unknown [75.142.155.118]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id BDA2A348011; Thu, 2 Sep 2010 15:56:46 -0700 (PDT) Subject: Re: Correction: datatypes are not "faster" From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Josh Berkus Cc: Tom Lane , pgsql-docs@postgresql.org In-Reply-To: <4C802428.5000504@agliodbs.com> References: <4C80208B.4060908@agliodbs.com> <15330.1283465619@sss.pgh.pa.us> <4C802428.5000504@agliodbs.com> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Thu, 02 Sep 2010 15:56:42 -0700 Message-ID: <1283468202.3791.315.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201009/31 X-Sequence-Number: 6021 > To this: > > On 32-bit operating systems, or when PostgreSQL is complied 32-bit, On 32-bit architectures, or when PostgreSQL is compiled as 32-bit binaries, operations using bigint may be slower than those with --- The problem I have with words like significant is that bigint is not noticeably slower. It is statistically slower (am I saying that right?). Sure if you "test" it, bigint will come out slower. Real world suggests that nobody is going to notice. JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt