Re: transitive pruning optimization on the right side of a join for partition tables

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: "Waldo, Ethan" <ewaldo(at)healthetechs(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: transitive pruning optimization on the right side of a join for partition tables
Date: 2012-09-30 11:24:07
Message-ID: CAM6mieL5iF58aeNzg7yUjnRCNLLzanb5Th6vQCXPO8b6-qcObw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 30 September 2012 21:00, Waldo, Ethan <ewaldo(at)healthetechs(dot)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(dot)ivanic(at)gmail(dot)com)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mr Dash Four 2012-09-30 12:53:57 strange permission error
Previous Message Waldo, Ethan 2012-09-30 11:00:18 Re: transitive pruning optimization on the right side of a join for partition tables