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 typesIs 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.