Re: when do I analyze after concurrent index creation?

Поиск
Список
Период
Сортировка
От dinesh kumar
Тема Re: when do I analyze after concurrent index creation?
Дата
Msg-id CALnrH7oSiXQcBGRrD6c+NErykb_zkHEDKMD3CaG2KmwEcxWmbA@mail.gmail.com
обсуждение исходный текст
Ответ на when do I analyze after concurrent index creation?  (AI Rumman <rummandba@gmail.com>)
Ответы Re: when do I analyze after concurrent index creation?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Hi,

When we create an index, i believe the postgres engine it self update it's catalog about the index availability.

"ANALYZE" helps you to find the right plan according to the number of rows got selected. I don't think, "ANALYZE" take care of updating the index entries.

I might be wrong here, hope someone will give you better information.

Thanks,
Dinesh



On Fri, Oct 18, 2013 at 1:13 AM, AI Rumman <rummandba@gmail.com> wrote:
Hi,

I have a very basic question.
If I create index concurrently, then do I need to analyze the table? If yes, when?
Please let me know.

Thanks. 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How do I create a box from fields in a table?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: when do I analyze after concurrent index creation?