varchar(n) vs. varchar - Mailing list pgsql-general

From Daniel Serodio
Subject varchar(n) vs. varchar
Date
Msg-id 1156246696.431151.48180@p79g2000cwp.googlegroups.com
Whole thread Raw
Responses Re: varchar(n) vs. varchar
List pgsql-general
I've found a thread discussing the use of "text" vs. "varchar"; what
I'd like to know if there's any performance difference between using
"varchar(n)" vs. "varchar", ie, should I constrain a "name" column to
an arbitrary length to improve performance, or will it actually degrade
performance because of the extra cycles used for checking the length?


pgsql-general by date:

Previous
From: "nuno"
Date:
Subject: error msg when pg_restore
Next
From: "A. Kretschmer"
Date:
Subject: Re: unique constraint when updating tables