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 0BDD29FB24C for ; Fri, 28 Jul 2006 07:23:04 -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 27714-07 for ; Fri, 28 Jul 2006 07:23:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from grzm.com (grzm.com [200.46.204.98]) by postgresql.org (Postfix) with ESMTP id 86CB69FB225 for ; Fri, 28 Jul 2006 07:22:32 -0300 (ADT) Received: from localhost (unknown [200.46.208.251]) by grzm.com (Postfix) with ESMTP id E1842127D413 for ; Fri, 28 Jul 2006 11:22:16 +0100 (BST) Received: from grzm.com ([200.46.204.98]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 27148-10; Fri, 28 Jul 2006 07:22:16 -0300 (ADT) Received: from [172.16.1.101] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id 083C3127CBC9; Fri, 28 Jul 2006 11:21:59 +0100 (BST) In-Reply-To: <44C9CCC8.8020304@libero.it> References: <44C9CCC8.8020304@libero.it> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <6ACD839C-D68A-4BD1-804F-B9DEACFC2ED1@seespotcode.net> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: primary keys as TEXT Date: Fri, 28 Jul 2006 19:21:20 +0900 To: Manlio Perillo X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.083 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200607/352 X-Sequence-Number: 25926 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? Michael Glaesemann grzm seespotcode net