2013/2/4 Anne Rosset <arosset@xxxxxxxxxx>: > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
