Re: [GENERAL] Parallel query only when EXPLAIN ANALYZEd

2016-09-30 Thread Jay Knight
(it launched workers with and without explain analyze), so I've only been able to reproduce this on Windows. Thanks, Jay K On Thu, Sep 29, 2016 at 9:07 PM David Rowley <david.row...@2ndquadrant.com> wrote: > On 30 September 2016 at 10:47, Jay Knight <j...@jayknight.com> wr

Re: [GENERAL] Parallel query only when EXPLAIN ANALYZEd

2016-09-29 Thread Jay Knight
y K On Thu, Sep 29, 2016 at 4:29 PM David Rowley <david.row...@2ndquadrant.com> wrote: > On 30 September 2016 at 08:52, Jay Knight <j...@jayknight.com> wrote: > > So, why might postgres parallelize the query when I explain analyze it, > but > > not when I just run it by itself

[GENERAL] Parallel query only when EXPLAIN ANALYZEd

2016-09-29 Thread Jay Knight
Hello, I installed 9.6 on Windows 7, and am experimenting with the new parallel query feature. I've found a behavior that seems inconsistent to me. Consider these two tables: create table t1 as ( with r as ( SELECT generate_series(1,30) AS id, ceil(random()*25)::int as item,