Re: Parallel query only when EXPLAIN ANALYZEd - Mailing list pgsql-general

From Tom Lane
Subject Re: Parallel query only when EXPLAIN ANALYZEd
Date
Msg-id 29733.1475254055@sss.pgh.pa.us
Whole thread Raw
In response to Re: Parallel query only when EXPLAIN ANALYZEd  (Jay Knight <jay@jayknight.com>)
Responses Re: Parallel query only when EXPLAIN ANALYZEd  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-general
Jay Knight <jay@jayknight.com> writes:
> I've tried this on a CentOS VM (VirtualBox on Windows) that I gave 2 cores,
> and it worked as expected (it launched workers with and without explain
> analyze), so I've only been able to reproduce this on Windows.

FWIW, I tried your original example on Linux yesterday, and it seemed to
work fine --- it only wanted to use 1 worker, but the speedup was just
about exactly 2X with or without "explain analyze".  So this is somehow
Windows specific.  That's darn odd; in a quick look at the relevant code
I see nothing that looks platform dependent.

Somebody will need to trace through this on Windows and see where it's
going off the rails.

            regards, tom lane


pgsql-general by date:

Previous
From: Jay Knight
Date:
Subject: Re: Parallel query only when EXPLAIN ANALYZEd
Next
From: Tim Clarke
Date:
Subject: Re: [ANNOUNCE] pgAdmin 4 v1.0 Released!