Home > mailing lists

CHAR vs VARCHAR w/TOAST - Mailing list pgsql-general

From	Brent R. Matzelle
Subject	CHAR vs VARCHAR w/TOAST
Date	June 4, 2001 12:52:53
Msg-id	CONTRACT1r4piiAk1b500000001@contract1.asdev.activestrategy.com Whole thread Raw
Responses	Re: CHAR vs VARCHAR w/TOAST (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

I read in the Changes list for 7.1 the following line:

CHAR() no longer faster than VARCHAR() because of TOAST
(Tom)

Does this mean that scanning is just as fast using VARCHAR
as CHAR?  I was always taught to use CHAR on columns that I
needed speedier search results.  What are the facts?

Brent

pgsql-general by date:

From: Bruce Momjian
Date: 04 June 2001, 12:51:39
Subject: Re: PostgreSQL security concerns

From: will trillich
Date: 04 June 2001, 13:05:10
Subject: Re: datestyle

CHAR vs VARCHAR w/TOAST - Mailing list pgsql-general

Previous

Next