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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jud Gardner <jgardner(at)comprehend(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15232: Query execution changes based on using 'explain analyze' or not
Date: 2018-06-07 17:06:33
Message-ID: 26469.1528391193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jud Gardner <jgardner(at)comprehend(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message D'Arcy Cain 2018-06-07 18:20:00 Re: chkpass Major Issue - compares 'contains' and not 'equal'
Previous Message Tom Lane 2018-06-07 16:08:55 Re: BUG #15232: Query execution changes based on using 'explain analyze' or not