From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Massive performance issues
Date: Thu, 1 Sep 2005 15:53:47 -0400
Message-ID: <20050901195347.GA31519@surnet.cl> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD25F@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD25F@Herge.rcsinc.local>
On Thu, Sep 01, 2005 at 03:51:35PM -0400, Merlin Moncure wrote:
> > Huh, hang on -- AFAIK there's no saving at all by doing that. Quite
> > the opposite really, because with char(x) you store the padding
> > blanks, which are omitted with varchar(x), so less I/O (not
> > necessarily a measurable amount, mind you, maybe even zero because
> > of padding issues.)
>
> You are right, all this time I thought there was a 4 byte penalty for
> storing varchar type and not in char :(. So there is no reason at all
> to use the char type?
Other than SQL conformance, apparently not.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
After collecting 500 such letters, he mused, a university somewhere in
Arizona would probably grant him a degree. (Don Knuth)
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-performance@postgresql.org
Cc: alvherre@alvh.no-ip.org, merlin.moncure@rcsonline.com
Subject: Re: Massive performance issues
In-Reply-To: <20050901195347.GA31519@surnet.cl>
* 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