Re: BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.

On 12/6/21 3:57 AM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      17321
> Logged by:          Denis Campredon
> Email address:      deni_@hotmail.fr
> PostgreSQL version: 13.3
> Operating system:   count(*) slow on partitioned table
> Description:        
> 
> I am auditing a database which has a really huge partitioned table.
> When working on the whole table queries are slower than the cumulated time
> for all partitions, as you can see with the following query. I don't have
> yet timings for more complex operations like group by, but it looks like it
> is slower than it should be.


If I'm reading this correctly, it counted 1579 rows /per millisecond/.
How may rows do you think it should have counted per millisecond?
-- 
Vik Fearing