Multicolumn index for single-column queries?

Поиск
Список
Период
Сортировка
От rihad
Тема Multicolumn index for single-column queries?
Дата
Msg-id 95ade9a3-6846-3f55-f936-85b8bb4b46a8@mail.ru
обсуждение исходный текст
Ответы Re: Multicolumn index for single-column queries?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Multicolumn index for single-column queries?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
Hi. Say there are 2 indexes:

     "foo_index" btree (foo_id)

     "multi_index" btree (foo_id, approved, expires_at)


foo_id is an integer. Some queries involve all three columns in their WHERE clauses, some involve only foo_id.
Would it be ok from general performance standpoint to remove foo_index and rely only on multi_index? I know that
PG would have to do less work updating just one index compared to updating them both, but wouldn't searches
on foo_id alone become slower?

Thanks.




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

Предыдущее
От: Julie Nishimura
Дата:
Сообщение: Re: ERROR: operator class "gin__int_ops" does not exist for accessmethod "gin"
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: Multicolumn index for single-column queries?