text .vs. varchar - Mailing list pgsql-general

From Joao Ferreira
Subject text .vs. varchar
Date
Msg-id 1218541744.6460.30.camel@jmf-ubuntu
Whole thread Raw
Responses Re: text .vs. varchar  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
Hello all,

I have a big database in which much information is stored in TEXT type
columns (I did this initially because I did not want to limit the
maximum size of the string to be stored)... but...

.. let's say I choose an upper limit (p.ex. 200) for the string sizes
and I start a fresh database with VARCHAR(200).

What tradeoffs can I expect ? disk usage ? query execution times ?

thx
Joao



pgsql-general by date:

Previous
From: Daneel
Date:
Subject: Newbie [CentOS 5.2] service postgresql initdb
Next
From: ries van Twisk
Date:
Subject: Re: different results based solely on existence of index (no, seriously)