Re: varchar vs. text - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: varchar vs. text
Date
Msg-id 200107111356.f6BDuR419767@jupiter.us.greatbridge.com
Whole thread Raw
In response to varchar vs. text  (Rachit Siamwalla <rachit@ensim.com>)
Responses Re: varchar vs. text  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
Rachit Siamwalla wrote:
>
> Is there any good reason to use VARCHAR over TEXT for a string field? ie.
> performance hits, etc.
>
> Other than running into the row size limit problem, are there any large
> storage / performance penalties of using TEXT for virtually all strings?
   Er  -  what kind of "row size limit"? I remember vaguely that   there was something the like in ancient releases,
but forgot   the specific restrictions.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



pgsql-hackers by date:

Previous
From: Mark Volpe
Date:
Subject: Re: Postgresql bulk fast loader
Next
From: Peter Eisentraut
Date:
Subject: Re: libpq autoconf scripts?