Re: GEQO plans much slower than standard join plans

2025-10-28 Thread Tomas Vondra
On 10/28/25 16:43, Carlo Sganzerla wrote: >> Another question is whether the difference is in planning or execution. >> I'd expect geqo=on makes planning faster and execution slower, but maybe >> that's not true for your test. It shouldn't be difficult to verify using >> pg_stat_statements (which t

Re: GEQO plans much slower than standard join plans

2025-10-28 Thread Carlo Sganzerla
> Another question is whether the difference is in planning or execution. > I'd expect geqo=on makes planning faster and execution slower, but maybe > that's not true for your test. It shouldn't be difficult to verify using > pg_stat_statements (which tracks both plan and exec time). We started ex