Re: Datatypes and performance

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