Indexes on Character Types

From: val(at)webtribe(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Indexes on Character Types
Date: 2004-07-28 11:31:00
Message-ID: 20040728113157.9A05E1834E@cheetah.webtribe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the 7.3 documentation about character data types
(http://www.postgresql.org/docs/7.3/static/datatype-
character.html), it states:
"Tip: There are no performance differences between these* three
types, apart from the increased storage size when using the
blank-padded type."
*referencing character, character varying and text data types

Is that statement applicable to indexes applied to those
columns? Is there any difference in performance for an index
applied to a character, character varying and text data type?

Your input will be appreciated and will help to put an end to a
debate.

TIA,
Val

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2004-07-28 11:41:27 EXPLAIN on DELETE statements
Previous Message Pierre-Frédéric Caillaud 2004-07-28 11:24:51 Re: Discussion wanted: 'Trigger on Delete' cascade.