From: Manlio Perillo <manlio_perillo@libero.it>
To: Michael Glaesemann <grzm@seespotcode.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: primary keys as TEXT
Date: Fri, 28 Jul 2006 22:06:01 +0200
Message-ID: <44CA6E29.4000201@libero.it> (raw)
In-Reply-To: <6ACD839C-D68A-4BD1-804F-B9DEACFC2ED1@seespotcode.net>
References: <44C9CCC8.8020304@libero.it>
<6ACD839C-D68A-4BD1-804F-B9DEACFC2ED1@seespotcode.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: manlio_perillo@libero.it, grzm@seespotcode.net
Subject: Re: primary keys as TEXT
In-Reply-To: <44CA6E29.4000201@libero.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox