Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 720E51336FA7 for ; Wed, 29 Dec 2010 13:25:42 -0400 (AST) 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 72760-02 for ; Wed, 29 Dec 2010 17:25:35 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm26-vm0.bullet.mail.sp2.yahoo.com (nm26-vm0.bullet.mail.sp2.yahoo.com [98.139.91.230]) by mail.postgresql.org (Postfix) with SMTP id 8FFF6133616B for ; Wed, 29 Dec 2010 13:25:34 -0400 (AST) Received: from [98.139.91.63] by nm26.bullet.mail.sp2.yahoo.com with NNFMP; 29 Dec 2010 17:25:33 -0000 Received: from [98.139.91.56] by tm3.bullet.mail.sp2.yahoo.com with NNFMP; 29 Dec 2010 17:25:33 -0000 Received: from [127.0.0.1] by omp1056.mail.sp2.yahoo.com with NNFMP; 29 Dec 2010 17:25:33 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 490119.96246.bm@omp1056.mail.sp2.yahoo.com Received: (qmail 3045 invoked by uid 60001); 29 Dec 2010 17:25:33 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1293643533; bh=Gfak8yKYJA44/+wyz8kEZl+vxtCX3804b7xZbP5gMKs=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Yp3bjmvLy2DrDS7K1G4FiEtRYORdbpsHovIFLT7dtDmYKgi7VRY2nD1ps+YgADeVtUEG0plGJjnuuCkevQQHp3HyON8h43T8IAivlwVnX5ILAk4XownW+bV8ABgBlGvJZgIPxUUKhWrNtqryfvoCdID90ukOEmYm+uWoHygg7/Y= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=slZQ6En518B97Pm+Ul7yjXWr1NYxfFpxfB7VAMTBJwvWWa1Zevjgl3B0xsXYHhk0n4Qrlv2h+MmpVeaexIvlugc6bRUBSNXiEn9GBPuvWeM+/KsZsLigYEBpgVAu89zuVqMu3sq8DSt7d2NCCDTr9yJnbUL5OyMwndxdKe5ZlQY=; Message-ID: <15263.96309.qm@web110704.mail.gq1.yahoo.com> X-YMail-OSG: CkHv9mgVM1lgaSmoRGq7QXogCml6_3mCloov43aRPffznaD qSX2cMfTtG.67oqBXosYPeeJn1l5_ITQ48zFOxZEPe2TiMRjtKKyb3yoXzT. wURyhhYl0fHg6AH1pWgNnV6YT3S2LJ0WP7ySlF19emSMk7HPEvDAyMR3jkuf jhVXeKtm_VFOGZxEoiRg72DK42aeNKvTF4gdslK8Rw64gQr0qHHK9mEZtnN4 1OLJZJcihIlWGawUGEpSwps7p9ZRSW.DkI.VjQWF4rleDIAR8VXsnZmPLRSl RD9ZPkxrXrd0NLW4z94L86v5lKSTLo5ro6vnE0IM6cWSpsLJmxs_O8R5x7bU xcABnnM31Gv7e7Z_UC6F29AE406g0_pw7_1pwbg35Obqh3KWdd6vZ7cWCFY6 w3ItScmMtEDE- Received: from [65.94.247.127] by web110704.mail.gq1.yahoo.com via HTTP; Wed, 29 Dec 2010 09:25:32 PST X-Mailer: YahooMailClassic/11.4.20 YahooMailWebService/0.8.107.285259 Date: Wed, 29 Dec 2010 09:25:32 -0800 (PST) From: Leslie S Satenstein Subject: Re: Words missing in the following txt To: Robert Haas Cc: pgsql-docs@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.908 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/49 X-Sequence-Number: 6285 =0A =0A=0A--- On Wed, 12/29/10, Robert Haas wrote:= =0A=0A> From: Robert Haas =0A> Subject: Re: [DOCS] W= ords missing in the following txt=0A> To: "Leslie S Satenstein" =0A> Cc: pgsql-docs@postgresql.org=0A> Date: Wednesday, Decembe= r 29, 2010, 6:45 AM=0A> On Sun, Dec 26, 2010 at 8:28 PM,=0A> Leslie S Saten= stein=0A> =0A> wrote:=0A> > In 8.1.1. Integer Types= =0A> >=0A> > The ending sentence in the 2nd paragraph reads...=0A> >=0A> > = The bigint type should only be used if the integer=0A> range is insufficien= t, because the latter is definitely=0A> faster.=0A> >=0A> > Integers are bi= gger or smaller, the sentence could=0A> read better if phrased as follows:= =0A> >=0A> > Use regular integers for fast efficient execution. The=0A> big= int type should only be used if the integer range is=0A> insufficient.=0A> = =0A> The original phrasing might be a little too cute in the=0A> sense that= =0A> "the latter" could be taken to refer to "the integer range"=0A> rather= =0A> than "the integer data type", but the intended meaning is=0A> pretty= =0A> obvious in context.=A0 I think your revised phrasing is=0A> more negat= ive=0A> about bigints than we actually want to be.=A0 I think=0A> bigints a= lso=0A> provide fast, efficient execution (compare with, say,=0A> numeric) = but=0A> they are not AS fast as integers.=0A> =0A> -- =0A> Robert Haas=0A> = EnterpriseDB: http://www.enterprisedb.com=0A> The Enterprise PostgreSQL Com= pany=0A> =0A> -- =0A> Sent via pgsql-docs mailing list (pgsql-docs@postgres= ql.org)=0A> To make changes to your subscription:=0A> http://www.postgresql= .org/mailpref/pgsql-docs=0A=0AA good compromise is to perhaps consider the = following.=0A=0AThe bigint type should only be used if the integer range is= insufficient, because calculation with the latter is definitely faster.=0A