Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7DE489FB2E9 for ; Wed, 19 Sep 2007 12:36:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 36018-02-2 for ; Wed, 19 Sep 2007 12:36:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 2FEE79FB2E4 for ; Wed, 19 Sep 2007 12:36:21 -0300 (ADT) Received: from [10.224.31.73] (unknown [38.98.147.68]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id A61B95649E; Wed, 19 Sep 2007 15:36:19 +0000 (UTC) In-Reply-To: <874pic0way.fsf@oxford.xeocode.com> References: <874pic0way.fsf@oxford.xeocode.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: "Stefan Arentz" , Content-Transfer-Encoding: 7bit From: Decibel! Subject: Re: Speeding up schema changes Date: Wed, 19 Sep 2007 10:04:50 -0500 To: Gregory Stark X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/135 X-Sequence-Number: 29348 On Sep 3, 2007, at 7:26 AM, Gregory Stark wrote: > Also, incidentally do you have a good reason to use CHAR instead of > varchar or > text? char(64) will take 64 bytes (actually 68 bytes in 8.2) even > if you don't > store anything more in it. text or varchar will take only as many > bytes as the > data you're storing (plus 4 bytes). Hrm, do we actually pad before storing? ISTM we should really do that the other way around... -- Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828