andr-sokolov commented on PR #1525: URL: https://github.com/apache/cloudberry/pull/1525#issuecomment-3739745382
I suggest join_collapse_limit=8 to reduce the difference from PostgreSQL 14, but you can consider slightly larger values. In the table below there are time and memory consumption to process the query from the test. | join_collapse_limit | Query processing time, ms | Backend memory usage | | --- | ---: | --- | | 8 | 96 | 52 MB | | 9 | 230 | 88 MB | | 10 | 653 | 210 MB | | 11 | 1269 | 394 MB | | 12 | 2994 | 889 MB | | 13 | 9003 | 2.4 GB | | 14 | 27245 | 7.3 GB | | 15 | 80904 | 22 GB | | 16 | 670578 | 66 GB | | 17 | 4158314 | 200 GB | Query processing time was got using `\timing on` in psql. Backend memory usage was measured at the end of the `planner` function -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
