On Wed, Oct 05, 2005 at 12:21:35PM -0600, Cristian Prieto wrote:
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?
They are essentially the same. Note that you can have varchar without length
(well, up to about a gigabyte or so after compression), and you can have
varchar with a length well above 255 (say, 100000).

/* Steinar */

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 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