text .vs. varchar

Поиск
Список
Период
Сортировка
От Joao Ferreira
Тема text .vs. varchar
Дата
Msg-id 1218541744.6460.30.camel@jmf-ubuntu
обсуждение исходный текст
Ответы Re: text .vs. varchar
Список 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 по дате отправления: