Re: Hash join explain is broken

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Hash join explain is broken
Дата
Msg-id 93FA6FE5-03C5-4AB1-B0D8-C1FA00C72121@anarazel.de
обсуждение исходный текст
Ответ на Re: Hash join explain is broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Hash join explain is broken  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

On June 13, 2019 3:38:47 PM PDT, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Andres Freund <andres@anarazel.de> writes:
>> I am too tired to look further into this. I suspect the only reason
>we
>> didn't previously run into trouble with the executor stashing
>hashkeys
>> manually at a different tree level with:
>> ((HashState *) innerPlanState(hjstate))->hashkeys
>> is that hashkeys itself isn't printed...
>
>TBH, I think 5f32b29c is just wrong and should be reverted for now.
>If there's a need to handle those expressions differently, it will
>require some cooperation from the planner not merely a two-line hack
>in executor startup.  That commit didn't include any test case or
>other demonstration that it was solving a live problem, so I think
>we can leave it for v13 to address the issue.

I'm pretty sure you'd get an assertion failure if you reverted it (that's why it was added). So it's a bit more
complicatedthan that.  Unfortunately I'll not get back to work until Monday, but I'll spend time on this then. 

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Obsolete comments about semaphores in proc.c
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Parallel grouping sets