Re: [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause

Please find the patch attached below for your review. Thanks & Regards, Ravi Revathy Member Technical Staff ZOHO Corporation On Wed, 27 Nov 2024 18:41:13 +0530 Ravi wrote --- Hi Developers,      Currently, PostgreSQL relies on table statistics, extracted within

[PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause

cardinality estimation is valid? If not, I would appreciate suggestions or corrections regarding this approach. Thanks & Regards, Ravi Revathy Member Technical Staff ZOHO Corporation

Re: [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause

  Batches: 1  Memory Usage: 44kB ->  Seq Scan on t1  (cost=0.00..15.00 rows=1000 width=4) (actual time=0.023..0.155 rows=1000 loops=1) Planning Time: 0.197 ms Execution Time: 12.218 ms (11 rows) Thanks & Regards, Ravi Revathy Member Technical Staff ZOHO Corporation

Re: [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause

& Regards, Ravi Revathy Member Technical Staff ZOHO Corporation On Tue, 18 Mar 2025 14:56:48 +0530 Ilia Evdokimov wrote --- Hi, On commit 122a9af I can't see any problem with query: explain analyze select * from t1 left join (select a, max(b) from t2 group by a) t