From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
Cc: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: GIN index not used |
Date: | 2014-07-11 04:56:14 |
Message-ID: | 20680.1405054574@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Andreas Kretschmer <akretschmer(at)spamfence(dot)net> writes:
> Huang, Suya <Suya(dot)Huang(at)au(dot)experian(dot)com> wrote:
>> Ive got a table with GIN index on integer[] type. While doing a query with
>> filter criteria on that column has GIN index created, its not using index at
>> all, still do the full table scan. Wondering why?
> Btw.: works for me:
Yeah, me too:
regression=# create table booking_weekly(booking_ts int[]);
CREATE TABLE
regression=# create index on booking_weekly using gin (booking_ts);
CREATE INDEX
regression=# explain select * from booking_weekly where booking_ts@>array[2446685];
QUERY PLAN
--------------------------------------------------------------------------------------------
Bitmap Heap Scan on booking_weekly (cost=8.05..18.20 rows=7 width=32)
Recheck Cond: (booking_ts @> '{2446685}'::integer[])
-> Bitmap Index Scan on booking_weekly_booking_ts_idx (cost=0.00..8.05 rows=7 width=0)
Index Cond: (booking_ts @> '{2446685}'::integer[])
Planning time: 0.862 ms
(5 rows)
What PG version is this? What non-default planner parameter settings are
you using? (Don't say "none", because I can see you've got enable_seqscan
turned off.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2014-07-11 05:01:23 | Re: GIN index not used |
Previous Message | Andreas Kretschmer | 2014-07-11 04:44:52 | Re: GIN index not used |