On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay O'Connor wrote:
> Based on the docs, they say that there's not performance difference between
> using varchar(n) and text.
>
> So will leaving my fields as unlimited varchar be a performance issue? Or
> should I try to narrow them down?
In fact, there is a performance penalty for limiting their length,
because you have to check on each insert.
> My coworker has more experience with Oracle and MS-SQL than postgresql
You may want to tell your coworker to read the docs ;-)
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110