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.
