Re: Partial Index Creation

Поиск
Список
Период
Сортировка
От Armand du Plessis
Тема Re: Partial Index Creation
Дата
Msg-id CANf99sV=Uz3XNmKMFXs+p0HP=vz3MbtCAjv+PzektfiRJocGDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partial Index Creation  (Strahinja Kustudić <strahinjak@nordeus.com>)
Список pgsql-admin

On Fri, Nov 22, 2013 at 10:34 PM, Strahinja Kustudić <strahinjak@nordeus.com> wrote:
Nice question, I would also like to know this.

Btw, why do you want to create a new partial index which is already covered by a regular index? Do you want to remove that regular index after creating the partial one?

Something like that yes. The new index incorporates columns not covered by the existing index as well as a more restrictive conditional expression. 

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

Предыдущее
От: Strahinja Kustudić
Дата:
Сообщение: Re: INSERT performance tuning experiences
Следующее
От: Masaru Sugawara
Дата:
Сообщение: Re: ぷららサポートセンター[04M013112200395]