From: Decibel! <decibel@decibel.org>
To: Gregory Stark <stark@enterprisedb.com>
Cc: Stefan Arentz <stefan.arentz@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Speeding up schema changes
Date: Wed, 19 Sep 2007 10:04:50 -0500
Message-ID: <FC6AC0ED-3C3B-41F4-A6DA-75C1F0B34042@decibel.org> (raw)
In-Reply-To: <874pic0way.fsf@oxford.xeocode.com>
References: <adf34c300709030422p7a5bf9ban915c01547c3cb008@mail.gmail.com>
<874pic0way.fsf@oxford.xeocode.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: decibel@decibel.org, stark@enterprisedb.com, stefan.arentz@gmail.com
Subject: Re: Speeding up schema changes
In-Reply-To: <FC6AC0ED-3C3B-41F4-A6DA-75C1F0B34042@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox