From: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
---|---|
To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com> |
Subject: | Re: Parallel Bitmap scans a bit broken |
Date: | 2017-03-09 16:32:12 |
Message-ID: | CAFiTN-vSFVYoQLg+ET13Wgtt63XXuP7pswwcg3oH88Nu9oa7og@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Mar 9, 2017 at 9:37 PM, Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>> =# create table r1(value int);
>> CREATE TABLE
>> =# insert into r1 select (random()*1000)::int from
>> generate_Series(1,1000000);
>> INSERT 0 1000000
>> =# create index on r1 using brin(value);
>> CREATE INDEX
>> =# set enable_seqscan=0;
>> SET
>> =# explain select * from r1 where value=555;
>
> I am looking into the issue, I have already reproduced it. I will
> update on this soon.
>
> Thanks for reporting.
I slightly modified your query to reproduce this issue.
explain analyze select * from r1 where value<555;
Patch is attached to fix the problem.
--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
parallel_bitmap_fix.patch | application/octet-stream | 755 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-09 16:44:24 | Re: partial indexes and bitmap scans |
Previous Message | Joe Conway | 2017-03-09 16:31:42 | Re: [bug fix] dblink leaks unnamed connections |