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

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: infinite loop in parallel hash joins / DSA / get_best_segment
Дата
Msg-id CAEepm=3Bo0WCXmuyacSR6Oc90rPOe6Vop7_o07p4g9Mf5U0q7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: infinite loop in parallel hash joins / DSA / get_best_segment  (Thomas Munro <thomas.munro@enterprisedb.com>)
Ответы Re: infinite loop in parallel hash joins / DSA / get_best_segment  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On Mon, Sep 17, 2018 at 9:12 PM Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> On Mon, Sep 17, 2018 at 10:42 AM Thomas Munro
> <thomas.munro@enterprisedb.com> wrote:
> > On Mon, Sep 17, 2018 at 10:38 AM Tomas Vondra
> > <tomas.vondra@2ndquadrant.com> wrote:
> > > While performing some benchmarks on REL_11_STABLE (at 444455c2d9), 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:
> > >
> > > ...
>
> With the attached draft patch, Tomas's benchmark script runs happily
> for long periods.  A bit more study required with fresh eyes,
> tomorrow.

Here is a tidied up version that I propose to back-patch to 10 & 11.

-- 
Thomas Munro
http://www.enterprisedb.com

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Online verification of checksums
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Allow concurrent-safe open() and fopen() in frontend code for Wi