[Bug] optimizer query plan cloudberry vs greenplum #609
Labels
type: Performance
cloudberry runs slow on some particular query
Content-Length: 268947 | pFad | http://github.com/apache/cloudberry/issues/609
F3
Cloudberry Database version
PostgreSQL 14.4 (Cloudberry Database 1.0.0+344efe8 build dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20231218 (Red Hat 11.4.1-3), 64-bit compi
led on Jul 2 2024 11:37:20
and
PostgreSQL 12.12 (Greenplum Database 7.1.0 build commit:e7c2b1f14bb42a1018ac57d14f4436880e0a0515 Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC)
8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Jan 19 2024 06:49:03 Bhuvnesh C.
(1 row)
What happened
greenplum 7.1 is faster than cloudberry here are the explain analyze:
What you think should happen instead
all databases had the same data and acutal statistics, greenplum is faster than cloudberry please find out why and optimize cloudberry
How to reproduce
count
GROUP BY
HAVING count() > 1000000
ORDER BY count() desc;
on a large table query the data with greenplum and with cloudberry
Operating System
RHEL 8 greenplum, RHEL9 cloudberry
Anything else
talked to Max Yang via Slack he told me to create this Issue.
There is a long discussion in cloudberry slack.
Are you willing to submit PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: