| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Datatypes and performance |
| Date: | 2003-07-04 19:54:56 |
| Message-ID: | 20030704195455.GT4707@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maksim Likharev | 2003-07-04 20:14:52 | Re: Datatypes and performance |
| Previous Message | Tom Lane | 2003-07-04 19:53:55 | Re: any body using Solaris8 with postgresql 7.3.3 |