Re: Performance improvement for joins where outer side is unique

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Performance improvement for joins where outer side is unique
Дата
Msg-id CAB7nPqRcJHk2eVKu5CNSH64KJg4zKnoHKRDP1+H1TAGOJjvTFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance improvement for joins where outer side is unique  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
On Thu, Dec 17, 2015 at 10:17 PM, David Rowley
<david.rowley@2ndquadrant.com> wrote:
> On 17 December 2015 at 19:11, Simon Riggs <simon@2ndquadrant.com> wrote:
>>
>> On 17 December 2015 at 00:17, Tomas Vondra <tomas.vondra@2ndquadrant.com>
>> wrote:
>>>
>>> I'd go with match_first_tuple_only.
>>
>>
>> +1
>>
>> unique_inner is a state that has been detected, match_first_tuple_only is
>> the action we take as a result.
>>
>
> Ok great. I've made it so in the attached. This means the comment in the
> join code where we perform the skip can be a bit less verbose and all the
> details can go in where we're actually setting the match_first_tuple_only to
> true.

Patch moved to next CF because of a lack of reviews on the new patch,
and because the last patch has been posted not so long ago.
-- 
Michael



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Using quicksort for every external sort run
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: PATCH: use foreign keys to improve join estimates v1