Re: transitive pruning optimization on the right side of a join for partition tables - Mailing list pgsql-general

Hi,

On 30 September 2012 21:00, Waldo, Ethan <ewaldo@healthetechs.com> wrote:
> Yeah, I actually saw that paper but couldn't find a date on it.  Currently their techniques are well outside
> of the scope of my current problem particularly in consideration that I could switch to MySQL which does support
> the right side join pruning.  I figured if MySQL can do it, there might be a good chance Postgres can too or will
soon.

Google says 2010 (Google Scholar). I was in the same position 2 years
ago but I was able to change / optimise our BI solution. Good to know
that MySQL can do this.

--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)