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

From Amit Langote
Subject Re: ANALYZE command progress checker
Date
Msg-id 1e7106aa-5cd6-2d43-7e3f-5c774d526aab@lab.ntt.co.jp
Whole thread Raw
In response to Re: ANALYZE command progress checker  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
On 2017/04/04 14:15, Amit Langote wrote:
> 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.

Sorry again, I meant *no* single-table statistics partitioned tables...

Thanks,
Amit





pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] Incremental sort
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: Re: Statement timeout behavior in extended queries