Speed of varchar vs. char in indices - Mailing list pgsql-general

From Mirko Zeibig
Subject Speed of varchar vs. char in indices
Date
Msg-id 20010124155331.B22257@picard.inka.de
Whole thread Raw
Responses Re: Speed of varchar vs. char in indices  (Alfred Perlstein <bright@wintelcom.net>)
List 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

pgsql-general by date:

Previous
From: John Frank
Date:
Subject: HASH: Out of overflow pages. Out of luck.
Next
From: clemens schmuck
Date:
Subject: groups a user belongs to