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,100));
create index test_idx on test using gin(v);
set work_mem = '16MB';
select count(*) from test where v 0.9;
count
───
99916
(1
On 05/10/2014 10:41 PM, Alexander Korotkov wrote:
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,100));
create index test_idx on test using gin(v);
set work_mem = '16MB';
select count(*)