Re: Problem in Parallel Bitmap Heap Scan?

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Problem in Parallel Bitmap Heap Scan?
Дата
Msg-id CAA4eK1LpQR9Pgw66Ouko2YptBQDQM-NWLuuvTZ8Td=qMQo4ZRw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Problem in Parallel Bitmap Heap Scan?  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-hackers
On Tue, Mar 21, 2017 at 5:51 PM, Dilip Kumar <dilipbalaut@gmail.com> wrote:
> On Tue, Mar 21, 2017 at 4:47 PM, Thomas Munro
> <thomas.munro@enterprisedb.com> wrote:
>> I noticed a failure in the inet.sql test while running the regression
>> tests with parallelism cranked up, and can reproduce it interactively
>> as follows.  After an spgist index is created and the plan changes to
>> the one shown below, the query returns no rows.
>
> Thanks for reporting.  Seems like we are getting issues related to
> TBM_ONE_PAGE and TBM_EMPTY.
>
> I think in this area we need more testing, reason these are not tested
> properly because these are not the natural case for parallel bitmap.
> I think in next few days I will test more such cases by forcing the
> parallel bitmap.
>

Okay, is your testing complete?

> Here is the patch to fix the issue in hand.  I have also run the
> regress suit with force_parallel_mode=regress and all the test are
> passing.
>

Thomas, did you get chance to verify Dilip's latest patch?

I have added this issue in PostgreSQL 10 Open Items list so that we
don't loose track of this issue.

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: crashes due to setting max_parallel_workers=0
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: scram and \password