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_(at)hotmail(dot)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