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.
gin_lossy_bitmap_fix.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
