Re: primary keys as TEXT - Mailing list pgsql-sql

From Manlio Perillo
Subject Re: primary keys as TEXT
Date
Msg-id 44CA6E29.4000201@libero.it
Whole thread Raw
In response to Re: primary keys as TEXT  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: primary keys as TEXT  ("Aaron Bono" <postgresql@aranya.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: primary keys as TEXT
Next
From: Fabian Peters
Date:
Subject: UPDATE with WHERE clause on joined table