X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8F4449FB285 for ; Fri, 28 Jul 2006 17:03:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82730-01 for ; Fri, 28 Jul 2006 17:03:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp8.libero.it (smtp8.libero.it [193.70.192.92]) by postgresql.org (Postfix) with ESMTP id 242B59FB282 for ; Fri, 28 Jul 2006 17:03:36 -0300 (ADT) Received: from localhost (172.16.1.80) by smtp8.libero.it (7.0.027-DD01) id 4464C62706F2D25B; Fri, 28 Jul 2006 22:03:35 +0200 Received: from smtp2.libero.it ([172.16.1.225]) by localhost (asav2.libero.it [193.70.192.151]) (amavisd-new, port 10024) with ESMTP id 07721-08; Fri, 28 Jul 2006 22:03:35 +0200 (CEST) Received: from [151.55.225.227] (unknown [151.55.225.227]) by smtp2.libero.it (Postfix) with ESMTP id B8C58A8C17; Fri, 28 Jul 2006 22:03:34 +0200 (MEST) Message-ID: <44CA6E29.4000201@libero.it> Date: Fri, 28 Jul 2006 22:06:01 +0200 From: Manlio Perillo User-Agent: Mozilla Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Michael Glaesemann CC: pgsql-sql@postgresql.org Subject: Re: primary keys as TEXT References: <44C9CCC8.8020304@libero.it> <6ACD839C-D68A-4BD1-804F-B9DEACFC2ED1@seespotcode.net> In-Reply-To: <6ACD839C-D68A-4BD1-804F-B9DEACFC2ED1@seespotcode.net> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Scanned: with antispam and antivirus automated system at libero.it X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200607/363 X-Sequence-Number: 25937 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