| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Speed & Memory Management |
| Date: | 2003-04-03 19:47:49 |
| Message-ID: | 1049399269.13798.5329.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2003-04-03 at 13:22, Jodi Kanter wrote:
> In response to the speed and memory management messages posted. Can
> someone tell me if the varchar(N) data type also impedes performance by
> padding with spaces?
> Thank you,
> Jodi
>
Well no since varchar doesn't pad spaces. Theoretically this does make
it an improvement over char, although by this same theory it does have
to do length checks on the input strings, which would slow things down
versus text data types *in theory*.
Don't forget also that a varchar(30) will _prevent_ strings longer than
30 chars, not truncate them.
Robert Treat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A.Bhuvaneswaran | 2003-04-04 05:05:51 | Re: 7.2.3 -> 7.3.2: timeofday(), server crashed |
| Previous Message | Kris Kiger | 2003-04-03 19:26:36 | Re: Speed & Memory Management |