Re: [sqlsmith] Parallel worker crash on seqscan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [sqlsmith] Parallel worker crash on seqscan
Дата
Msg-id 28497.1479752734@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [sqlsmith] Parallel worker crash on seqscan  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Nov 21, 2016 at 1:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hah: not where I thought it was at all.  The problem seems to be down to
>> the optimization I put into is_parallel_safe() awhile back to skip testing
>> anything if we previously found the entire querytree to be parallel-safe.
>> Well, the raw query tree *is* parallel-safe.  It's only when we inject
>> some Params that we have a parallel hazard.  So that optimization is too
>> optimistic :-(

> That sucks.  Any idea how we might salvage it?

I just disabled it by checking to see if any Params have been created.
It might be possible to be more refined, but I dunno that adding more
bookkeeping would pay for itself.
        regards, tom lane



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Patch to implement pg_current_logfile() function
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: delta relations in AFTER triggers