Thread: 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