Indexes on Character Types

[val]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Alvaro Herrera]

On Wed, Jul 28, 2004 at 12:31:00PM +0100, va*@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.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend