Re: infinite loop in parallel hash joins / DSA / get_best_segment

2018-09-19 Thread Thomas Munro
On Tue, Sep 18, 2018 at 11:35 AM Thomas Munro wrote: > On Mon, Sep 17, 2018 at 9:12 PM Thomas Munro > wrote: > > On Mon, Sep 17, 2018 at 10:42 AM Thomas Munro > > wrote: > > > On Mon, Sep 17, 2018 at 10:38 AM Tomas Vondra > > > wrote: > > > > While performing some benchmarks on REL_11_STABLE (a

Re: infinite loop in parallel hash joins / DSA / get_best_segment

2018-09-17 Thread Thomas Munro
On Mon, Sep 17, 2018 at 9:12 PM Thomas Munro wrote: > On Mon, Sep 17, 2018 at 10:42 AM Thomas Munro > wrote: > > On Mon, Sep 17, 2018 at 10:38 AM Tomas Vondra > > wrote: > > > While performing some benchmarks on REL_11_STABLE (at 55c2d9), I've > > > repeatedly hit an apparent infinite loop o

Re: infinite loop in parallel hash joins / DSA / get_best_segment

2018-09-17 Thread Thomas Munro
On Mon, Sep 17, 2018 at 10:42 AM Thomas Munro wrote: > On Mon, Sep 17, 2018 at 10:38 AM Tomas Vondra > wrote: > > While performing some benchmarks on REL_11_STABLE (at 55c2d9), I've > > repeatedly hit an apparent infinite loop on TPC-H query 4. I don't know > > what exactly are the triggering

Re: infinite loop in parallel hash joins / DSA / get_best_segment

2018-09-16 Thread Thomas Munro
On Mon, Sep 17, 2018 at 10:38 AM Tomas Vondra wrote: > While performing some benchmarks on REL_11_STABLE (at 55c2d9), I've > repeatedly hit an apparent infinite loop on TPC-H query 4. I don't know > what exactly are the triggering conditions, but the symptoms are these: > > 1) A parallel worke

infinite loop in parallel hash joins / DSA / get_best_segment

2018-09-16 Thread Tomas Vondra
Hi, While performing some benchmarks on REL_11_STABLE (at 55c2d9), I've repeatedly hit an apparent infinite loop on TPC-H query 4. I don't know what exactly are the triggering conditions, but the symptoms are these: 1) A parallel worker" process is consuming 100% CPU, with per for reporting p