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

Поиск
Список
Период
Сортировка
От Ondrej Ivanič
Тема Re: transitive pruning optimization on the right side of a join for partition tables
Дата
Msg-id CAM6mieL5iF58aeNzg7yUjnRCNLLzanb5Th6vQCXPO8b6-qcObw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: transitive pruning optimization on the right side of a join for partition tables  ("Waldo, Ethan" <ewaldo@healthetechs.com>)
Список 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)


В списке pgsql-general по дате отправления:

Предыдущее
От: "Waldo, Ethan"
Дата:
Сообщение: Re: transitive pruning optimization on the right side of a join for partition tables
Следующее
От: Mr Dash Four
Дата:
Сообщение: strange permission error