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

Re: Disadvantages to using "text"

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Disadvantages to using "text"
Date: 2008-05-07 16:55:14
Message-ID: 4821DEF2.8070405@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

Responses

pgsql-novice by date

Next:From: Bruce MomjianDate: 2008-05-07 17:20:05
Subject: Re: [NOVICE] encoding problems
Previous:From: Tom LaneDate: 2008-05-07 16:54:51
Subject: Re: Disadvantages to using "text"

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