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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
