Missing hook for UPPERREL_PARTIAL_GROUP_AGG rels?

Started by Erik Nordströmover 6 years ago3 messages
#1Erik Nordström
erik@timescale.com

Hi,

I noticed that the create_upper_paths_hook is never called for partially
grouped rels. Is this intentional or a bug? Only the FDW routine's
GetForeignUpperPaths hook is called for partially grouped rels. This seems
odd since the regular create_upper_paths_hook gets called for all other
upper rels.

Regards,

Erik
Timescale

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Erik Nordström (#1)
Re: Missing hook for UPPERREL_PARTIAL_GROUP_AGG rels?

=?UTF-8?Q?Erik_Nordstr=C3=B6m?= <erik@timescale.com> writes:

I noticed that the create_upper_paths_hook is never called for partially
grouped rels. Is this intentional or a bug? Only the FDW routine's
GetForeignUpperPaths hook is called for partially grouped rels. This seems
odd since the regular create_upper_paths_hook gets called for all other
upper rels.

This seems possibly related to the discussion re set_rel_pathlist_hook
at

/messages/by-id/CADsUR0AaPx4sVgmnuVJ_bOkocccQZGubv6HajzW826rbSmFpCg@mail.gmail.com

I don't think we've quite resolved what to do there, but maybe
create_upper_paths_hook needs to be looked at at the same time.

regards, tom lane

#3Erik Nordström
erik@timescale.com
In reply to: Tom Lane (#2)
Re: Missing hook for UPPERREL_PARTIAL_GROUP_AGG rels?

Thanks for the quick response. I do think this might be a separate issue
because in the set_rel_pathlist_hook case, that hook is actually called at
one point. In this case there is simply no place in the PostgreSQL code
where a call is made to create_upper_paths_hook for the
UPPERREL_PARTIAL_GROUP_AGG upper rel kind. See
create_partial_grouping_paths().

Regards,

Erik

On Thu, Jun 27, 2019 at 8:58 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Show quoted text

=?UTF-8?Q?Erik_Nordstr=C3=B6m?= <erik@timescale.com> writes:

I noticed that the create_upper_paths_hook is never called for partially
grouped rels. Is this intentional or a bug? Only the FDW routine's
GetForeignUpperPaths hook is called for partially grouped rels. This

seems

odd since the regular create_upper_paths_hook gets called for all other
upper rels.

This seems possibly related to the discussion re set_rel_pathlist_hook
at

/messages/by-id/CADsUR0AaPx4sVgmnuVJ_bOkocccQZGubv6HajzW826rbSmFpCg@mail.gmail.com

I don't think we've quite resolved what to do there, but maybe
create_upper_paths_hook needs to be looked at at the same time.

regards, tom lane