Speed of varchar vs. char in indices

From: Mirko Zeibig <mirko(at)picard(dot)inka(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Speed of varchar vs. char in indices
Date: 2001-01-24 14:53:31
Message-ID: 20010124155331.B22257@picard.inka.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a table:

CREATE TABLE pge (
pge_id SERIAL,
pge_path CHAR(255) CONSTRAINT ak_pge_path UNIQUE,
PRIMARY KEY (pge_id)
);

From other tables I now reference pge_id as well as pge_path. Somewhere I
have read that indices on CHAR are faster than those on VARCHAR.

Any remarks?

TIA
Mirko

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond Chui 2001-01-24 14:55:46 Postgres Client other than Linux?
Previous Message Alexander Klimov 2001-01-24 14:48:19 LO to text conversion