Re: Text/Varchar performance... - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Text/Varchar performance...
Date
Msg-id 20051005183441.GA32451@uio.no
Whole thread Raw
In response to Text/Varchar performance...  ("Cristian Prieto" <cristian@clickdiario.com>)
List pgsql-performance
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 */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Jeffrey W. Baker"
Date:
Subject: Re: [HACKERS] A Better External Sort?
Next
From: "Merlin Moncure"
Date:
Subject: Re: Ultra-cheap NVRAM device