Re: [GENERAL] Parallel query only when EXPLAIN ANALYZEd

2016-09-30 Thread Jay Knight
t worked as expected (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 wrote: > On 30 September 2016 at 10:47, Jay Knight wrote: > >>What's max_worker_proc

Re: [GENERAL] Parallel query only when EXPLAIN ANALYZEd

2016-09-29 Thread Jay Knight
Thanks, Jay K On Thu, Sep 29, 2016 at 4:29 PM David Rowley wrote: > On 30 September 2016 at 08:52, Jay Knight wrote: > > So, why might postgres parallelize the query when I explain analyze it, > but > > not when I just run it by itself? > > One theory would be that, t

[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, ceil(random