On Tue, 2010-04-27 at 10:29 -0700, Josh Berkus wrote:
> In addition to the new replication, a number of new features will allow
> developers and DBAs to broaden their use of PostgreSQL, including:
>
> * Support for 64-bit Windows
> * Redesigned LISTEN/NOTIFY built-in event notifications
> * The DO() statement, allowing users to execute ad-hoc procedural statements
> * Conditional and Column Triggers
> * Numerous PL/Perl improvements
> * Uniqueness constraints for non-scalar data
> * Improved key-value data support
I think the join removal feature is of critical importance, much more so
than many of the above items.
I might describe it like in *one* of these ways
* Automatic join removal to optimise complex SQL generated by OR mapping
* Major new optimizations for complex automatically generated SQL
--
Simon Riggs www.2ndQuadrant.com