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 63A1FD1DC2E for ; Sun, 7 Mar 2004 14:49:10 +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 55371-10 for ; Sun, 7 Mar 2004 10:49:12 -0400 (AST) Received: from fep02-mail.bloor.is.net.cable.rogers.com (fep02-mail.bloor.is.net.cable.rogers.com [66.185.86.72]) by svr1.postgresql.org (Postfix) with ESMTP id 2DB71D1DC2D for ; Sun, 7 Mar 2004 10:49:08 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep02-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040307144829.TGWB434741.fep02-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Sun, 7 Mar 2004 09:48:29 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 1D1413F4B; Sun, 7 Mar 2004 09:49:07 -0500 (EST) Date: Sun, 7 Mar 2004 09:49:07 -0500 From: Andrew Sullivan To: pgsql-performance Subject: Re: Fixed width rows faster? Message-ID: <20040307144907.GA23162@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance References: <20040306162658.GB20089@phlogiston.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep02-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Sun, 7 Mar 2004 09:48:27 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/88 X-Sequence-Number: 5944 On Sun, Mar 07, 2004 at 02:42:41PM +0100, Dennis Bjorklund wrote: > The error however comes when you try to insert the value. Doing a reindex > will not change the length of the value and will always work. I didn't do a good job in my quoting, but this is what I meant. It'd surely be a bug if you could get a value into an indexed field, but couldn't later rebuild that index. A -- Andrew Sullivan | ajs@crankycanuck.ca The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun