Re: Avoiding surrogate keys

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Avoiding surrogate keys
Дата
Msg-id 4BDC8BA9.9080604@hogranch.com
обсуждение исходный текст
Ответ на Avoiding surrogate keys  (Thom Brown <thombrown@gmail.com>)
Ответы Re: Avoiding surrogate keys  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
If your 'natural key' is a large text field, I'd have to assume there's
some point at which a surrogate index would be more efficient.  Would
this be above a few dozen characters, or a few 100 characters?   I
wouldn't want a PK based on a multi-K byte text field for a table that
has many 10s or 100s of 1000s of rows, for sure.





В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: PostgreSQL vs. Microsoft SQL server
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: PostgreSQL vs. Microsoft SQL server