| Lists: | pgsql-bugs |
|---|
| From: | Ruslan A Dautkhanov <rusland(at)scn(dot)ru> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | datatypes: text vs varchar |
| Date: | 2002-12-08 13:28:45 |
| Message-ID: | 3DF3490D.FBCEEB5F@scn.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Hello,
Can anybody tell us - how much 'text' datatype harder for
database vs 'varchar(xx)' datatype? How much queries, which
use this types differ in performance? We use only 'text'
fields. Is 'varchar' (without specifying width) synonym
for 'text', or not? Thanks.
---
best regards,
Ruslan A Dautkhanov rusland(at)scn(dot)ru
| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Ruslan A Dautkhanov <rusland(at)scn(dot)ru> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: datatypes: text vs varchar |
| Date: | 2002-12-08 17:44:27 |
| Message-ID: | 1039369467.350.14.camel@tokyo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Sun, 2002-12-08 at 08:28, Ruslan A Dautkhanov wrote:
> Hello,
>
> Can anybody tell us - how much 'text' datatype harder for
> database vs 'varchar(xx)' datatype?
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/datatype-character.html
>From that page: "Tip: There are no performance differences between
these three types, apart from the increased storage size when using the
blank-padded type."
Cheers,
Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC