Re: About inheritance - Mailing list pgsql-general

From Tom Lane
Subject Re: About inheritance
Date
Msg-id 6211.1093196249@sss.pgh.pa.us
Whole thread Raw
In response to About inheritance  (Ioannis Theoharis <theohari@ics.forth.gr>)
Responses Prefetch children  (Ioannis Theoharis <theohari@ics.forth.gr>)
List pgsql-general
Ioannis Theoharis <theohari@ics.forth.gr> writes:
> I expekt to find the same plans because in both cases there is a union to
> be done, but i see that in second case there is an additional call to a
> routine. I meen the 'Subquery Scan "*SELECT* X"'

The subquery scan step is in there because in a UNION construct, there
may be a need to do transformations on the data before it can be
unioned.  For instance you are allowed to UNION an int4 and an int8
column, in which case the int4 values have to be promoted to int8 after
they come out of the subplan.

In the particular case you are showing, the subquery scan steps aren't
really doing anything, but AFAIR the planner does not bother to optimize
them out.  I'd be pretty surprised if they chew up any meaningful amount
of runtime.

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: Greatest/Least functions?
Next
From: Thomas Hallgren
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions