Re: [PERFORM] GIN index not used if created in the same transactionas query

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: [PERFORM] GIN index not used if created in the same transactionas query
Дата
Msg-id CAMjNa7e-Q9DwX4TZqtuQNkitf0b0W65NsW54u7HLnMU+m2pbkw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] GIN index not used if created in the same transaction as query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PERFORM] GIN index not used if created in the same transaction as query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
Does the "multiple steps" part involve UPDATEs on pre-existing rows?
Do the updates change the column(s) used in the gin index?
 
 Yes they do, however the updates happen prior to the index creation.
 
I just tried, and that looks like the solution.  I really appreciate your help on this.

Is there any easy way I can know if an index is usable or not? Are there any catalog views or anything I could check that in?

Thanks,
-Adam

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] GIN index not used if created in the same transaction as query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] GIN index not used if created in the same transaction as query