On Thu, Jun 11, 2015 at 01:27:23PM -0400, Tom Lane wrote: > Bruce Momjian <br...@momjian.us> 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 <br...@momjian.us> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers