X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 90F4DD1D5A6 for ; Fri, 5 Mar 2004 23:54:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 06871-09 for ; Fri, 5 Mar 2004 19:54:34 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5B300D1D2C6 for ; Fri, 5 Mar 2004 19:54:29 -0400 (AST) Received: from [134.22.70.251] (dyn-70-251.tor.dsl.tht.net [134.22.70.251]) by tht.net (Postfix) with ESMTP id 07D8776A81; Fri, 5 Mar 2004 18:54:35 -0500 (EST) Subject: Re: Fixed width rows faster? From: Rod Taylor To: Mike Nolan Cc: Josh Berkus , Bill Moran , Jeff , Postgresql Performance In-Reply-To: <200403052343.i25NhYsv021796@gw.tssi.com> References: <200403052343.i25NhYsv021796@gw.tssi.com> Content-Type: text/plain Message-Id: <1078530843.57624.24.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Fri, 05 Mar 2004 18:54:04 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/66 X-Sequence-Number: 5922 On Fri, 2004-03-05 at 18:43, Mike Nolan wrote: > > Frankly, the only reason to use anything other than TEXT is compatibility with > > other databases and applications. > > You don't consider a requirement that a field be no longer than a > certain length a reason not to use TEXT? Actually, I don't. Good reason to have a check constraint on it though (hint, check constraints can be changed while column types cannot be, at this moment).