Cristian,
Hello, just a little question, It's preferable to use Text Fields or
varchar(255) fields in a table? Are there any performance differences in
the use of any of them?
TEXT, VARCHAR, and CHAR use the same underlying storage mechanism. This
means that TEXT is actually the "fastest" since it doesn't check length or
space-pad. However, that's unlikely to affect you unless you've millions
of records; you should use the type which makes sense given your
application.

For "large text fields" I always use TEXT. BTW, in PostgreSQL VARCHAR is
not limited to 255; I think we support up to 1GB of text or something
preposterous.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 5 | next ›
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedOct 5, '05 at 6:24p
activeOct 10, '05 at 12:54p
posts5
users4
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase