Datatype sizes; a space and speed issue?

Поиск
Список
Период
Сортировка
От Madison Kelly
Тема Datatype sizes; a space and speed issue?
Дата
Msg-id 40D8F882.4020507@alteeve.com
обсуждение исходный текст
Ответы Re: Datatype sizes; a space and speed issue?  (Vams <vmudrageda@charter.net>)
Re: Datatype sizes; a space and speed issue?  (Joel Matthew <rees@ddcom.co.jp>)
Список pgsql-general
Hi again,

   Something I have been wondering about and haven't found an answer to
yet is how the size of a datatype (I hope that is the right term)
effects performance. What effect is there if I specify "TEXT" instead of
say "VARCHAR(255)"? How much benefit is there do being more aggresive
and say cutting it in half again by using "VARCHAR(128)"?

   I hope this isn't too basic a question! Thanks!

Madison

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Connection gets into state where all queries fail
Следующее
От: Joel Matthew
Дата:
Сообщение: incremental backups?