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