On Sat, Oct 5, 2024 at 11:30 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Here’s a comparison of Execution Time and Planning Time for the seven
> queries with eager aggregation disabled versus enabled (best of 3).
>
> Execution Time:
>
> EAGER-AGG-OFF EAGER-AGG-ON
>
> q4 105787.963 ms 34807.938 ms
> q8 1407.454 ms 1654.923 ms
> q11 67899.213 ms 18670.086 ms
> q23 45945.849 ms 42990.652 ms
> q31 10463.536 ms 10244.175 ms
> q33 2186.928 ms 2217.228 ms
> q77 2360.565 ms 2416.674 ms
Could you attach the EXPLAIN ANALYZE output for these queries, with
and without the patch?
--
Robert Haas
EDB: http://www.enterprisedb.com