From: Tom Lane <tgl@sss.pgh.pa.us>
To: Leslie S Satenstein <lsatenstein@yahoo.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: Words missing in the following txt
Date: Wed, 29 Dec 2010 12:46:02 -0500
Message-ID: <25261.1293644762@sss.pgh.pa.us> (raw)
In-Reply-To: <15263.96309.qm@web110704.mail.gq1.yahoo.com>
References: <15263.96309.qm@web110704.mail.gq1.yahoo.com>
Leslie S Satenstein <lsatenstein@yahoo.com> writes:
> A good compromise is to perhaps consider the following.
> The bigint type should only be used if the integer range is insufficient, because calculation with the latter is definitely faster.
This doesn't seem to me to fix the basic problem, which is that "the
latter" appears to refer to "integer range". You don't calculate with
ranges, but with types. Maybe it should be
The bigint type should only be used if the range of the integer
type is insufficient, because the latter is definitely faster.
I'm not that excited about making the text specify that calculations are
faster, because on most modern machines the actual calculation speed
difference is pretty minuscule. What's expensive about bigint is
pushing around twice as much data and/or having to do palloc's.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, lsatenstein@yahoo.com, robertmhaas@gmail.com
Subject: Re: Words missing in the following txt
In-Reply-To: <25261.1293644762@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox