varchar(n) vs. varchar

From: "Daniel Serodio" <dserodio(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: varchar(n) vs. varchar
Date: 2006-08-22 11:38:16
Message-ID: 1156246696.431151.48180@p79g2000cwp.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2006-08-22 12:44:24 GNUmed release (uses PostgreSQL)
Previous Message Alban Hertroys 2006-08-22 10:30:13 Re: Queries joining views