CHAR vs VARCHAR w/TOAST

From: "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>
To: PG General <pgsql-general(at)postgresql(dot)org>
Subject: CHAR vs VARCHAR w/TOAST
Date: 2001-06-04 13:45:16
Message-ID: CONTRACT1r4piiAk1b500000001@contract1.asdev.activestrategy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-06-04 13:51:24 Re: PostgreSQL security concerns
Previous Message Andrew Gould 2001-06-04 12:50:58 RE: editing postgresql.conf for network access