Postgres Pro
Downloads
Home   >   mailing lists

varchar(n) and text - Mailing list pgsql-general

From Yan Cheng Cheok
Subject varchar(n) and text
Date
Msg-id 55336.61312.qm@web65707.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: varchar(n) and text  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Tree view 
According to http://www.postgresql.org/docs/8.0/interactive/datatype-character.html

I always use TEXT, for column which store text so that I need not to worry on text length.

However, in certain situation, I know that my text length will always < 10 characters

I was wondering, if I using TEXT, will there have any overhead on

(1) storage space?
(2) query performance?
(3) write performance?

Shall I just use varchar(10) ?

Thanks!

Thanks and Regards
Yan Cheng CHEOK

pgsql-general by date:

Previous
From: Yan Cheng Cheok
Date:
Subject: Shall I apply normalization in the following case?
Next
From: Bruce Momjian
Date:
Subject: Re: varchar(n) and text