Re: Indexes on individual columns of composite primary key

Поиск
Список
Период
Сортировка
От Matthew Walden
Тема Re: Indexes on individual columns of composite primary key
Дата
Msg-id AANLkTikSeBK9Nehdo06O0o=ujCirYcFCthGSCDx=E0yJ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Indexes on individual columns of composite primary key  (Dann Corbit <DCorbit@connx.com>)
Список pgsql-general
"Apparently (after reading the documentation link provided by Tom) there can be value to indexes when accessed with leading columns missing".

That is a new one on me too - interesting.

I suppose it comes down to testing at the end of the day - if you "set enable_seqscan to false" and "EXPLAIN ANALYSE" your query then you will see whether the indexes you create are used.  Whether they are useful will require you to set enable_seqscan back to true and see whether the optimizer chooses to use them (but that will change as your data does).

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

Предыдущее
От: "Gauthier, Dave"
Дата:
Сообщение: v9 deployment advise
Следующее
От: Matthew Walden
Дата:
Сообщение: Re: Expected frequency of auto_vacuum activity