numerical primary key vs alphanumerical primary key

From: Anne Rosset <arosset(at)collab(dot)net>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: numerical primary key vs alphanumerical primary key
Date: 2013-02-04 21:52:39
Message-ID: 9A6B86D66BD3C2438AFACFA09354890F20698DDB@EXCH02.sp.corp.collab.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Виктор Егоров 2013-02-04 21:57:56 Re: numerical primary key vs alphanumerical primary key
Previous Message Dan Fairs 2013-02-04 21:14:58 Re: Simple join doesn't use index