Re: ANALYZE command progress checker - Mailing list pgsql-hackers

From Amit Langote
Subject Re: ANALYZE command progress checker
Date
Msg-id 35d480d4-f889-b0dd-0559-daf06da43d0f@lab.ntt.co.jp
Whole thread Raw
In response to [HACKERS] ANALYZE command progress checker  (vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>)
Responses Re: ANALYZE command progress checker  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List 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 by date:

Previous
From: Amit Langote
Date:
Subject: Re: ANALYZE command progress checker
Next
From: Andres Freund
Date:
Subject: Re: [PATCH] Incremental sort