(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
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
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,