Thread: Indexes on Character Types

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

On Wed, Jul 28, 2004 at 12:31:00PM +0100, val@webtribe.net wrote:
> 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?

Yes, no.  Apart from the increased storage size when using the
blank-padded type.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Criptografía: Poderosa técnica algorítmica de codificación que es
empleada en la creación de manuales de computadores.