From: Julien Cigar <jcigar@ulb.ac.be>
To: pgsql-performance@postgresql.org
Subject: Re: numerical primary key vs alphanumerical primary key
Date: Tue, 12 Feb 2013 14:06:57 +0100
Message-ID: <511A3E71.10604@ulb.ac.be> (raw)
In-Reply-To: <9A6B86D66BD3C2438AFACFA09354890F20698DDB@EXCH02.sp.corp.collab.net>
References: <9A6B86D66BD3C2438AFACFA09354890F20698DDB@EXCH02.sp.corp.collab.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
The biggest difference in performance between text and integer keys is
usually down to whether you're inserting in order or not. Inserting in
order is tons faster regardless of the type, since it keeps the index
unfragmented and doesn't cause page splits.
On 02/04/2013 22:52, Anne Rosset wrote:
>
> Hi,
>
> I have read a lot of different information about the benefits of using
> numerical primary key vs alphanumerical primary key(small size). And
> what I am gathering is that for performance there is no more great
> advantage.
>
> It seems like now RDBMS in general, postgres in particular handles
> pretty well joins on text indexes.
>
> Did I understand correctly?
>
> Thanks,
>
> Anne
>
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-performance@postgresql.org
Cc: jcigar@ulb.ac.be
Subject: Re: numerical primary key vs alphanumerical primary key
In-Reply-To: <511A3E71.10604@ulb.ac.be>
* 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