numerical primary key vs alphanumerical primary key - Mailing list pgsql-performance

From Anne Rosset
Subject numerical primary key vs alphanumerical primary key
Date
Msg-id 9A6B86D66BD3C2438AFACFA09354890F20698DDB@EXCH02.sp.corp.collab.net
Whole thread Raw
Responses Re: numerical primary key vs alphanumerical primary key  (Виктор Егоров <vyegorov@gmail.com>)
Re: numerical primary key vs alphanumerical primary key  (Julien Cigar <jcigar@ulb.ac.be>)
List 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

pgsql-performance by date:

Previous
From: Dan Fairs
Date:
Subject: Re: Simple join doesn't use index
Next
From: Виктор Егоров
Date:
Subject: Re: numerical primary key vs alphanumerical primary key