| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Jay O'Connor <joconnor(at)cybermesa(dot)com> |
| Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Datatypes and performance |
| Date: | 2003-07-04 15:28:12 |
| Message-ID: | 20030704152812.GB19733@dcc.uchile.cl |
| 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:
> I created a database schema and based on the test data I had to work with,
> I couldn't really determine the max size of a lot of string fields so I
> just left a lot of fields as varchar
>
> A comment from a coworker was that this would cause a performance problem
>
> Based on the docs, they say that there's not performance difference between
> using varchar(n) and text.
The only difference comes from checking the length for the limited
fields, so varchar(n) will be very slightly slower than text.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"There was no reply" (Kernel Traffic)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Weiping He | 2003-07-04 15:30:38 | Re: any body using Solaris8 with postgresql 7.3.3 |
| Previous Message | Andrew Sullivan | 2003-07-04 15:26:20 | Re: PostgreSQL vs. MySQL |