determining maxsize for character varying

Поиск
Список
Период
Сортировка
От okparanoid@free.fr
Тема determining maxsize for character varying
Дата
Msg-id 1181987590.4673b306d4baf@imp.free.fr
обсуждение исходный текст
Ответы Re: determining maxsize for character varying  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: determining maxsize for character varying  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Hello i would like to know if not determining a max size value for a character
varying's fields decrease the perfomance (perhaps size of stockage ? or
something else ?)

If not it is a good way to not specify a max size value ?
If it has an importance is it possible to have a general environnment variable
saying to postgres to automatically truncate fields which postgres have to
insert or update with a length superior at the max length.

Sorry for my bad english...

Lot of thanks

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Variable (degrading) perfomance
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: determining maxsize for character varying