Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ACCCD9FB336 for ; Wed, 18 Oct 2006 16:17:45 -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 92694-06 for ; Wed, 18 Oct 2006 16:17:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 120A99FB2CC for ; Wed, 18 Oct 2006 16:17:39 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id E14EA56467; Wed, 18 Oct 2006 14:17:38 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 18 Oct 2006 14:17:35 -0500 Date: Wed, 18 Oct 2006 14:17:34 -0500 From: "Jim C. Nasby" To: Merlin Moncure Cc: Mario Weilguni , pgsql-performance@postgresql.org, Alexander Staubo , Ruben Rubio Subject: Re: Optimization of this SQL sentence Message-ID: <20061018191734.GN85041@nasby.net> References: <45349CDF.3090002@rentalia.com> <4534A35E.9030909@rentalia.com> <181E6D21-8326-4ED6-A9AE-6F9917C1C319@purefiction.net> <200610171729.19596.mweilguni@sime.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061018:mmoncure@gmail.com::54olZ6vK08Fpd7ZS:0000000000000000000 00000000000000000000000034au X-Hashcash: 1:20:061018:mweilguni@sime.com::U2yB+RL0Px1t0FwV:0000000000000000000 00000000000000000000000007yg X-Hashcash: 1:20:061018:pgsql-performance@postgresql.org::Q3DArO99+8Wb2dXd:00000 00000000000000000000000023ll X-Hashcash: 1:20:061018:alex@purefiction.net::g4+YBtJFQjo+U/jp:00000000000000000 00000000000000000000000005Qc X-Hashcash: 1:20:061018:ruben@rentalia.com::EjKqFueEGbAltgUN:0000000000000000000 0000000000000000000000001RHB X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.046 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/366 X-Sequence-Number: 21495 On Tue, Oct 17, 2006 at 12:51:19PM -0400, Merlin Moncure wrote: > so, imo alexander is correct: > contacto varchar(255) > > ...is a false constraint, why exactly 255? is that were the dart landed? BTW, if we get variable-length varlena headers at some point, then setting certain limits might make sense to keep performance more consistent. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)