Re: [sqlsmith] Crash in apply_projection_to_path

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [sqlsmith] Crash in apply_projection_to_path
Дата
Msg-id 20535.1462033959@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [sqlsmith] Crash in apply_projection_to_path  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Amit Kapila <amit.kapila16@gmail.com> writes:
> On Fri, Apr 29, 2016 at 7:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> make_join_rel is certainly not far enough down the call stack to solve
>> this problem.  It can, and typically will, be invoked multiple times
>> for the same target join relation.
>> 
>> One possible answer is to do it in standard_join_search, just before
>> the set_cheapest call for each join relation.

> Yes, that makes sense to me.

Done that way.

> Yet, another idea could be to create a copy of partial path before passing
> it to create_gather_path()?

That's just a kluge, and I'm not exactly convinced it'd solve the problem
anyway, unless you wanted to recursively copy the entire infrastructure
of the partial path.  What's needed is to set rules for how we build paths
up in an orderly fashion.  Such rules already existed for regular paths
(see the comments I added in c45bf5751), and now they exist for parallel
paths as well.
        regards, tom lane



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: New 9.6 external sort guidance around temp_tablespaces and maintenance_work_mem
Следующее
От: Andre Mikulec
Дата:
Сообщение: Re: SPI_exec ERROR in pl/r of R 3.2.4 on PostgreSQL on Windows 7