Re: primary keys as TEXT

From: Manlio Perillo <manlio_perillo(at)libero(dot)it>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: primary keys as TEXT
Date: 2006-07-28 20:06:01
Message-ID: 44CA6E29.4000201@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Fabian Peters 2006-07-28 21:24:56 UPDATE with WHERE clause on joined table
Previous Message Scott Marlowe 2006-07-28 19:34:34 Re: primary keys as TEXT