Indexes on Character Types

Поиск
Список
Период
Сортировка
От val@webtribe.net
Тема Indexes on Character Types
Дата
Msg-id 20040728113157.9A05E1834E@cheetah.webtribe.net
обсуждение исходный текст
Ответы Re: Indexes on Character Types
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: Discussion wanted: 'Trigger on Delete' cascade.
Следующее
От: Janning Vygen
Дата:
Сообщение: EXPLAIN on DELETE statements