Two indexes on same column

Поиск
Список
Период
Сортировка
От Vlastimil Krejcir
Тема Two indexes on same column
Дата
Msg-id Pine.GSO.4.64.1107201101240.13966@dior.ics.muni.cz
обсуждение исходный текст
Ответы Re: Two indexes on same column  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Список pgsql-general
   Hi,

   what index is used (and according to what rules) when there are two (or
more) different indexes defined on one column? Assume:

CREATE TABLE example (
id SERIAL PRIMARY KEY,
...);
CREATE INDEX example_id_idx ON example USING hash (id);

By default there are btree index created and the hash index is then
created. So there are two indexes on column "id". Are there described
somewhere what index is used and when? Does it depend on query analyzer
and planner?

Thanks

Vlastik


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Building an home computer for best Poker Tracker performance
Следующее
От: Raghavendra
Дата:
Сообщение: Re: Two indexes on same column