Re: ANALYZE command progress checker

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: ANALYZE command progress checker
Дата
Msg-id 35d480d4-f889-b0dd-0559-daf06da43d0f@lab.ntt.co.jp
обсуждение исходный текст
Ответ на [HACKERS] ANALYZE command progress checker  (vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>)
Ответы Re: ANALYZE command progress checker
Список pgsql-hackers
On 2017/04/04 14:12, Amit Langote wrote:
> Two kinds of statistics are collected if the table is a inheritance parent.
> 
> First kind considers the table by itself and calculates regular
> single-table statistics using rows sampled from the only available heap
> (by calling do_analyze_rel() with inh=false).

Oops, should have also mentioned that this part is not true for the new
partitioned tables.  There are single-table statistics for partitioned
tables, because it contains no data.

Thanks,
Amit





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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: ANALYZE command progress checker
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH] Incremental sort