Re: Disadvantages to using "text"

From: Aurynn Shaw <ashaw(at)commandprompt(dot)com>
To: Frank Bax <fbax(at)sympatico(dot)ca>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Disadvantages to using "text"
Date: 2008-05-07 19:19:47
Message-ID: 482200D3.4050007@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Frank Bax wrote:
> Aurynn Shaw wrote:
>> Internally, Postgres treats a VARCHAR(n) as a TEXT with a CHECK
>> constraint applied to it, so VARCHAR is going to be slightly slower to
>> use.
>
>
> Don't you mean VARCHAR(n) will be slightly slower on UPDATES.

Yes, that is what I meant. Thank you. :)

--
Aurynn Shaw

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

ashaw(at)commandprompt(dot)com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2008-05-07 20:32:43 Re: [NOVICE] encoding problems
Previous Message Obe, Regina 2008-05-07 19:15:08 Re: Disadvantages to using "text"