On Thu, Jun 11, 2015 at 01:27:23PM -0400, Tom Lane wrote:
> Bruce Momjian <[email protected]> writes:
> > On Thu, Jun 11, 2015 at 05:16:07PM +1200, David Rowley wrote:
> >> Would you also be able to mention something about�f15821e and�d222585 ?
>
> > I am going to defer to Tom on that. I have added optimizer changes in
> > the past but he didn't feel it made sense unless there was some
> > user-visible change.
>
> I'd be inclined to document both of those. We mentioned outer join
> removal when it was first added, in 9.0, so making a significant
> improvement in it seems worthy of mention also. Both of these things
> are "user visible" to the extent that they affect EXPLAIN output.
>
> I'm not sure whether we need to document the semantic hazard that the
> second commit message worries about.
OK, I have added two items; applied patch attached.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
diff --git a/doc/src/sgml/release-9.5.sgml b/doc/src/sgml/release-9.5.sgml
new file mode 100644
index 98f2107..17301a4
*** a/doc/src/sgml/release-9.5.sgml
--- b/doc/src/sgml/release-9.5.sgml
***************
*** 242,247 ****
--- 242,262 ----
<listitem>
<para>
+ Allow the optimizer to remove unnecessary references to left
+ outer join subqueries (David Rowley)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Allow pushdown of query restrictions into <link
+ linkend="functions-window">window functions</>, where appropriate
+ (David Rowley)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Speed up <acronym>CRC</> (cyclic redundancy check) computations
(Abhijit Menon-Sen, Heikki Linnakangas)
</para>
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
