Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group