Re: Performance improvement for joins where outer side is unique

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Performance improvement for joins where outer side is unique
Дата
Msg-id CAKJS1f_4hm3qwKeHYKftd+BQuYBgdNR+rk+XP_JW9EY-ALHZbQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance improvement for joins where outer side is unique  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Performance improvement for joins where outer side is unique  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On 25 August 2015 at 17:25, David Rowley <david.rowley@2ndquadrant.com> wrote:
On 24 August 2015 at 14:29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
David Rowley <david.rowley@2ndquadrant.com> writes:
> I have to admit I don't much like it either, originally I had this as an
> extra property that was only seen in EXPLAIN VERBOSE.

Seems like a reasonable design from here. 

The attached patch has the format in this way.

I've attached a rebased patch against current master as there were some conflicts from the recent changes to LATERAL join.

On reviewing the patch again I was reminded that the bulk of the changes in the patch are in analyzejoins.c. These are mostly just a refactor of the current code to make it more reusable. The diff looks a bit more scary than it actually is.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
Вложения

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [PATCH] Equivalence Class Filters
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: [PATCH] Equivalence Class Filters