BUG #3701: Don't work intarray GIN indexes
The following bug has been logged online:
Bug reference: 3701
Logged by: girla
Email address: girla@online.ua
PostgreSQL version: 8.3beta1
Operating system: Windows XP Proffesional SP2
Description: Don't work intarray GIN indexes
Details:
8.3beta1 never used intarray GIN indexes.
The same test case:
EXPLAIN
SELECT *
FROM intarr
WHERE (arr && ARRAY[132,20,78,45,457]);
on 8.2:
--------------------
"Bitmap Heap Scan on intarr (cost=4.33..37.45 rows=10 width=64)"
" Recheck Cond: (arr && '{132,20,78,45,457}'::integer[])"
" -> Bitmap Index Scan on i_arr_gin (cost=0.00..4.33 rows=10 width=0)"
" Index Cond: (arr && '{132,20,78,45,457}'::integer[])"
and on 8.3beta1:
---------------------
"Seq Scan on intarr (cost=0.00..238.00 rows=10 width=58)"
" Filter: (arr && '{132,20,78,45,457}'::integer[])"
"girla" <girla@online.ua> writes:
8.3beta1 never used intarray GIN indexes.
Works for me:
contrib_regression=# \d test__int
Table "public.test__int"
Column | Type | Modifiers
--------+-----------+-----------
a | integer[] |
Indexes:
"text_idx" gin (a gin__int_ops)
contrib_regression=# SELECT count(*) from test__int WHERE a && '{23,50}';
count
-------
403
(1 row)
contrib_regression=# explain SELECT count(*) from test__int WHERE a && '{23,50}';
QUERY PLAN
-----------------------------------------------------------------------------
Aggregate (cost=25.18..25.19 rows=1 width=0)
-> Bitmap Heap Scan on test__int (cost=4.31..25.16 rows=7 width=0)
Recheck Cond: (a && '{23,50}'::integer[])
-> Bitmap Index Scan on text_idx (cost=0.00..4.31 rows=7 width=0)
Index Cond: (a && '{23,50}'::integer[])
(5 rows)
contrib_regression=#
(This is using the database set up by contrib/intarray's regression
test.)
So if you want help you're going to need to provide much more detail,
like say your *whole* test case.
regards, tom lane