Re: BUG #15232: Query execution changes based on using 'explain analyze' or not

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15232: Query execution changes based on using 'explain analyze' or not
Дата
Msg-id 26469.1528391193@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15232: Query execution changes based on using 'explain analyze'or not  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #15232: Query execution changes based on using 'explainanalyze' or not  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-bugs
Дерево обсуждения 
Jud Gardner <jgardner@comprehend.com> writes:
> When submitted through psql I don't see the issue.
> I also don't see it when submitting via jdbc (42.2.2) directly.

> I'm seeing this via jdbc through dbVisualizer, haven't seen this kind of
> behavior before.

Interesting.  It could be that dbVisualizer is setting some parameter
or transaction mode that prevents parallelism.  SERIALIZABLE mode
does so, for example, because the serializable-transaction logic
hasn't been taught about parallelism yet.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15232: Query execution changes based on using 'explain analyze' or not
Следующее
От: D'Arcy Cain
Дата:
Сообщение: Re: chkpass Major Issue - compares 'contains' and not 'equal'