From: Vik Fearing <vik@postgresfriends.org>
To: deni_@hotmail.fr
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.
Date: Sat, 11 Dec 2021 04:14:33 +0100
Message-ID: <93e50b9b-ffa4-2bfe-8b3c-5a286b9b2fc8@postgresfriends.org> (raw)
In-Reply-To: <17321-a10c625e59181269@postgresql.org>
References: <17321-a10c625e59181269@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: vik@postgresfriends.org, deni_@hotmail.fr, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17321: count(*) on a 1,874,554,883 rows partitioned table takes several minutes.
In-Reply-To: <93e50b9b-ffa4-2bfe-8b3c-5a286b9b2fc8@postgresfriends.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox