Skip site navigation (1) Skip section navigation (2)

Re: DRAFT beta release announcement

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>,PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: DRAFT beta release announcement
Date: 2010-04-30 14:34:17
Message-ID: 4bdaea6b.1408c00a.5b63.579d@mx.google.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Wed, Apr 28, 2010 at 11:15:52PM +0100, Simon Riggs wrote:
> On Wed, 2010-04-28 at 14:38 -0700, Josh Berkus wrote:
> > > I think the join removal feature is of critical importance, much more so
> > > than many of the above items.
> > 
> > I just don't have any figures on actual performance benefit from this,
> > which will be the *first* thing a reporter asks.
> 
> "Orders of magnitude" saving. It's not *faster* it just doesn't do the
> work at all any more.
> 
> > > 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
> > 
> > How about
> > 
> > * Optimization of ORM-generated queries through automatic join removal
> 
> Good. All 3 do it for me, but I think I'm too close to judge.

Is it worth considering that more than just ORMs are responsible for
machine-generated SQL, and just saying "machine-generated" instead of
"ORM-generated"? Provided, that is, that the extra four characters don't make
the line wrap :)

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

In response to

pgsql-advocacy by date

Next:From: Selena DeckelmannDate: 2010-04-30 16:44:54
Subject: Fwd: PostgreSQL speaker DESPERATELY NEEDED for Southeast Linuxfest
Previous:From: Peter EisentrautDate: 2010-04-30 06:43:42
Subject: Re: DRAFT beta release announcement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group