Lossy bitmap scan is broken in GIN
От
Alexander Korotkov
Тема
Lossy bitmap scan is broken in GIN
Дата
Msg-id
CAPpHfdv=OFLSPDDhy89+B0whXZdsU9PsueGNvNhV7CnAVakpQA@mail.gmail.com
Список
Дерево обсуждения
Lossy bitmap scan is broken in GIN Alexander Korotkov <aekorotkov@gmail.com>
Re: Lossy bitmap scan is broken in GIN Heikki Linnakangas <hlinnakangas@vmware.com>
Hackers,
GIN hangs on lossy bitmap scan. Here is test case:
create extension btree_gin;
create table test as (select random() v from generate_series(1,1000000));
create index test_idx on test using gin(v);
set work_mem = '16MB';
select count(*) from test where v > 0.9;
count
───────
99916
(1 row)
Time: 63,142 ms
set work_mem = '64kB';
select count(*) from test where v > 0.9;
The last query hangs. I've debugged it. It's another bug in this "cursed" loop in entryGetItem. Fix is attached.
With best regards,
Alexander Korotkov.
В списке pgsql-hackers по дате отправления
