Disadvantages to using "text"

From: "Don Mies (NIM)" <dmies(at)networksinmotion(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Disadvantages to using "text"
Date: 2008-05-07 15:52:27
Message-ID: 3329C5B4110B6F429B69A8D70AC74D0303A9B544@exchange1.NIMONE.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Are there any reasons for not using the "text" type whenever a variable
length string field is needed? Are there penalties in disk usage,
memory usage or performance?

What are the differences between declaring something "varchar" or
"varchar(n)" or "text"? (I realize that the middle one has an upper
limit while the others do not.)

Don

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rodrigo E. De León Plicet 2008-05-07 16:01:09 Re: Disadvantages to using "text"
Previous Message Bruce Momjian 2008-05-07 15:47:50 Re: [NOVICE] encoding problems