| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | galvao(at)galvao(dot)eti(dot)br |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: NUMERIC x VARCHAR |
| Date: | 2004-08-11 06:21:48 |
| Message-ID: | 1092205308.27166.358.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2004-08-10 at 23:42, Er Galvão Abbott wrote:
> Greetings.
>
> I have a question regarding performance of certain datatypes:
>
> I have a field where I will store my clients phone numbers. I know
> that this field will never exceed 15 characters, and I will store only
> numbers here (no dashes, dots, etc...), so I was wondering:
>
> Wich type is faster: NUMERIC(15,0) or VARCHAR(15)? Are there any
> storage differences between them?
Since numerics are stored as text strings, the storage would be
similar. Numerics, however, may be slower since they have more
constraints built in. If you throw a check constraint on the
varchar(15) then it will likely be about the same speed for updating.
text type with a check contraint it what i'd use. That way if you want
to change it at a later date you just drop and recreate your constraint.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre-Frédéric Caillaud | 2004-08-11 06:43:36 | Re: Hardware upgrade for a high-traffic database |
| Previous Message | Er Galvão Abbott | 2004-08-11 05:42:33 | NUMERIC x VARCHAR |