Re: primary keys as TEXT

Поиск
Список
Период
Сортировка
От Manlio Perillo
Тема Re: primary keys as TEXT
Дата
Msg-id 44CA6E29.4000201@libero.it
обсуждение исходный текст
Ответ на Re: primary keys as TEXT  (Michael Glaesemann <grzm@seespotcode.net>)
Ответы Re: primary keys as TEXT
Список pgsql-sql
Michael Glaesemann ha scritto:
> 
> On Jul 28, 2006, at 17:37 , Manlio Perillo wrote:
> 
>> There can be performancs problems in having primary keys of type TEXT?
>> What about having a primary key of 3 columns (all of type TEXT)?
> 
> What defines a problem in terms of performance is heavily dependent on
> your particular needs and requirements. What are your requirements? What
> profiling have you done to see where your performance bottlenecks may be?
> 

I still don't have done profiling.

Simply in the first version of my schema I used serial keys but the
result is ugly and it force me to do a lot of joins.




Thanks and regards  Manlio Perillo


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: primary keys as TEXT
Следующее
От: Fabian Peters
Дата:
Сообщение: UPDATE with WHERE clause on joined table