Tuesday, August 12, 2008

[GENERAL] text .vs. varchar

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: