Re: Automatic analyze on select into

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Automatic analyze on select into
Дата
Msg-id 8335.1051373934@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Automatic analyze on select into  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: Automatic analyze on select into  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
"Jim C. Nasby" <jim@nasby.net> writes:
> So, question is, would it make sense to automatically do an analyze
> after/during a SELECT INTO?

I don't think so.  Very often, temp tables are small and only used for
one or two operations anyway --- so the cost of an ANALYZE wouldn't be
repaid.  If ANALYZE would be useful, the user can issue one.

            regards, tom lane


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Automatic analyze on select into
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Automatic analyze on select into