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

From Vik Fearing
Subject Re: BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.
Date
Msg-id 93e50b9b-ffa4-2bfe-8b3c-5a286b9b2fc8@postgresfriends.org
Whole thread Raw
In response to BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: BUG #17300: Server crashes on deserializing text multirange
Next
From: Andres Freund
Date:
Subject: Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum