On 07.07.2025 16:49, Andrei Lepikhov wrote:
> Exposing internal information about the estimation of the number of
> groups in the Memoise node, shouldn't we do the same in even more
> vague cases, such as IncrementalSort? For example, in [1] (see its
> attachment), I observe that IncrementalSort is considerably better
> than Sort, but has a larger cost. It would be helpful to understand if
> an incorrect ngroups estimation causes this.
LGTM.
If we still don't expose any information for nodes like IncrementalSort
that would help explain why the planner chose them, then I fully agree -
we definitely should add it.
I suggest discussing that in a separate thread.
--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.
