determining maxsize for character varying - Mailing list pgsql-performance

From okparanoid@free.fr
Subject determining maxsize for character varying
Date
Msg-id 1181987590.4673b306d4baf@imp.free.fr
Whole thread Raw
Responses Re: determining maxsize for character varying  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: determining maxsize for character varying  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Variable (degrading) perfomance
Next
From: Andreas Kretschmer
Date:
Subject: Re: determining maxsize for character varying