Re: Does this matter?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
Cc: Wei Weng <wweng(at)kencast(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Does this matter?
Date: 2002-11-01 22:00:09
Message-ID: 200211011400.09915.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql


Phillip,

> Really? According to this url (search for "Tip") there is no performance
> difference just a space difference. I don't know for sure either way, but
> if there is a difference the manual needs updating.
>
> http://www.postgresql.org/idocs/index.php?datatype-character.html

Actually, that note is intended to tell people that CHAR is not any faster
than VARCHAR for the same-length string ... since CHAR *is* faster than
VARCHAR in some systems, like MS SQL Server.

--
-Josh Berkus

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Curtis Faith 2002-11-01 22:00:19 Re: Does this matter?
Previous Message Andrew Sullivan 2002-11-01 21:10:57 Re: Does this matter?

Browse pgsql-sql by date

  From Date Subject
Next Message Curtis Faith 2002-11-01 22:00:19 Re: Does this matter?
Previous Message Bruno Wolff III 2002-11-01 21:59:00 Re: select syntax question