datatypes: text vs varchar

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
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ruslan A Dautkhanov 2002-12-08 14:52:40 O_DIRECT option used?
Previous Message Tom Lane 2002-12-06 22:40:17 Re: GEQO Triggers Server Crash