Re: [GENERAL] varchar(n) vs. varchar

2006-08-22 Thread Tom Lane
"Daniel Serodio" <[EMAIL PROTECTED]> writes: > 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 perform

[GENERAL] varchar(n) vs. varchar

2006-08-22 Thread Daniel Serodio
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