Re: numerical primary key vs alphanumerical primary key

From: Виктор Егоров <vyegorov(at)gmail(dot)com>
To: Anne Rosset <arosset(at)collab(dot)net>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: numerical primary key vs alphanumerical primary key
Date: 2013-02-04 21:57:56
Message-ID: CAGnEboiqCz--QPy0ouYw910SDZLUpCnMOSVYzFisAiSXV3FdAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2013/2/4 Anne Rosset <arosset(at)collab(dot)net>:
> 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.

Please, take a look at this blog post:
http://www.depesz.com/2012/06/07/123-vs-depesz-what-is-faster/

--
Victor Y. Yegorov

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Will Platnick 2013-02-05 03:45:53 Slow Query Help
Previous Message Anne Rosset 2013-02-04 21:52:39 numerical primary key vs alphanumerical primary key