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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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