On Thu, May 16, 2013 at 06:49:33PM -0400, Tom Lane wrote:
> "'Bruce Momjian'" <bruce@momjian.us> writes:
> > On Thu, May 16, 2013 at 08:38:59PM +0530, Amit Kapila wrote:
> >> Reduce query processing overhead by avoiding insertion of useless plan nodes
> >> OR
> >> Improve performance of certain kind of queries by avoiding extra processing
> >> of doing projection
> >>
> >> This applies to queries doing identity projection ("SELECT * FROM ...") for
> >> partitioned tables.
>
> > Uh, that's pretty complex for our release notes, and hard to understand
> > for most users. All they will know is that PG is faster --- we don't
> > document every speedup.
>
> No, but this is user-visible if they look at EXPLAIN output, and people
> might wonder why they were getting different results.
>
> Possibly text like
>
> Omit unnecessary Result and Limit nodes from query plans.
Yes, that would be user-visible, though we rarely add details like that.
What queries are faster, that users would understand?
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +