pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Leslie S Satenstein <lsatenstein@yahoo.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: Words missing in the following txt
Date: Wed, 29 Dec 2010 09:25:32 -0800 (PST)
Message-ID: <15263.96309.qm@web110704.mail.gq1.yahoo.com> (raw)
In-Reply-To: <AANLkTi=VXxP+WwCB7YCBJrU3GACw89+cmaFPYPnOFVOk@mail.gmail.com>


 

--- On Wed, 12/29/10, Robert Haas <robertmhaas@gmail.com> wrote:

> From: Robert Haas <robertmhaas@gmail.com>
> Subject: Re: [DOCS] Words missing in the following txt
> To: "Leslie S Satenstein" <lsatenstein@yahoo.com>
> Cc: pgsql-docs@postgresql.org
> Date: Wednesday, December 29, 2010, 6:45 AM
> On Sun, Dec 26, 2010 at 8:28 PM,
> Leslie S Satenstein
> <lsatenstein@yahoo.com>
> wrote:
> > In 8.1.1. Integer Types
> >
> > The ending sentence in the 2nd paragraph reads...
> >
> > The bigint type should only be used if the integer
> range is insufficient, because the latter is definitely
> faster.
> >
> > Integers are bigger or smaller, the sentence could
> read better if phrased as follows:
> >
> > Use regular integers for fast efficient execution. The
> bigint type should only be used if the integer range is
> insufficient.
> 
> The original phrasing might be a little too cute in the
> sense that
> "the latter" could be taken to refer to "the integer range"
> rather
> than "the integer data type", but the intended meaning is
> pretty
> obvious in context.  I think your revised phrasing is
> more negative
> about bigints than we actually want to be.  I think
> bigints also
> provide fast, efficient execution (compare with, say,
> numeric) but
> they are not AS fast as integers.
> 
> -- 
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
> 
> -- 
> Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs

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.




view thread (5+ messages)  latest in thread

Message-ID: <15263.96309.qm@web110704.mail.gq1.yahoo.com>
Permalink:  ../15263.96309.qm@web110704.mail.gq1.yahoo.com/
Also on:    postgresql.org/message-id/15263.96309.qm@web110704.mail.gq1.yahoo.com

 · 

reply

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: lsatenstein@yahoo.com, robertmhaas@gmail.com
  Subject: Re: Words missing in the following txt
  In-Reply-To: <15263.96309.qm@web110704.mail.gq1.yahoo.com>

* 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