Re: Add important info about ANALYZE after create Functional Index

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: Add important info about ANALYZE after create Functional Index
Дата
Msg-id CAFcNs+p=T30HkfTTritZzWONbawrTpkd4gjyxAoPRMg-+O_iAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add important info about ANALYZE after create Functional Index  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Add important info about ANALYZE after create Functional Index
Список pgsql-hackers
Дерево обсуждения


On Mon, 9 Nov 2020 at 20:27 Bruce Momjian <bruce@momjian.us> wrote:

I see REINDEX CONCURRENTLY was fixed in head, but the docs didn't get
updated to mention the need to run ANALYZE or wait for autovacuum before
expression indexes can be fully used by the optimizer.  Instead of
putting this mention in the maintenance section, I thought the CREATE
INDEX page make more sense, since it is more of a usability issue,
rather than "why use expression indexes".  Patch attached, which I plan
to apply to all supported branches.
   

Did a quick review and totally agree... thanks a lot Bruce to help us don’t miss it.

Regards,


--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Add important info about ANALYZE after create Functional Index
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Hybrid Hash/Nested Loop joins and caching results from subplans