Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions.
От
Tom Lane
Тема
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions.
Дата
Msg-id
23425.1502822098@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [COMMITTERS] pgsql: Simplify plpgsql's check for simple expressions. Tom Lane <tgl@sss.pgh.pa.us>
Tom Lane writes: > Simplify plpgsql's check for simple expressions. > ... > https://git.postgresql.org/pg/commitdiff/00418c61244138bd8ac2de58076a1d0dd4f539f3 The buildfarm members that are running force_parallel_mode = regress are not happy with this. Apparently, even a trivial SELECT can be turned into a Gather plan if force_parallel_mode says so. I assume (haven't looked) that I could hack the plpgsql code to prevent generating a parallel plan when it's decided the command is a simple SELECT. But I wonder whether that's the right place to fix it. Does it ever make sense to parallelize a plan that can't possibly benefit? IOW I am not sure that we should carry force_parallel_mode this far. regards, tom lane
В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
От: Peter Geoghegan
Дата: