numerical primary key vs alphanumerical primary key

Поиск
Список
Период
Сортировка
От Anne Rosset
Тема numerical primary key vs alphanumerical primary key
Дата
Msg-id 9A6B86D66BD3C2438AFACFA09354890F20698DDB@EXCH02.sp.corp.collab.net
обсуждение исходный текст
Ответы Re: numerical primary key vs alphanumerical primary key
Re: numerical primary key vs alphanumerical primary key
Список 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 по дате отправления: