On Thu, Mar 9, 2017 at 9:37 PM, Dilip Kumar <dilipbal...@gmail.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
Description: Binary data
-- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers