Re: Parallel query only when EXPLAIN ANALYZEd

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: Jay Knight <jay(at)jayknight(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Parallel query only when EXPLAIN ANALYZEd
Date: 2016-09-30 21:10:33
Message-ID: 14775.1475269833@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> writes:
> On 1 October 2016 at 05:47, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Somebody will need to trace through this on Windows and see where it's
>> going off the rails.

> I tried the test case on 9.6.0 on a Windows 8.1 machine, and it works
> fine for me.

Hm, but if we assume that EXPLAIN ANALYZE is somehow affecting the
behavior, it's entirely plausible that having auto_explain active
would have the same effect.

Please try it without auto_explain, and just rely on noting the runtime
with psql's \timing to infer whether workers were active or not.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-09-30 21:14:40 Re: System crashed: fatal error restarting postgres
Previous Message Rakesh Kumar 2016-09-30 20:54:18 pgadmin vs psql output