Re: How can I get the query planner to use a bitmap index scap instead of an index scan ?

Hello folks,

I have a table of about 700k rows in Postgres 9.3.3, which has the
following structure:

Columns:
 content_body  - text
 publish_date  - timestamp without time zone
 published     - boolean

Indexes:
    "articles_pkey" PRIMARY KEY, btree (id)
    "article_text_gin" gin (article_text)
    "articles_publish_date_id_index" btree (publish_date DESC NULLS
LAST, id DESC)

   ->  Index Scan using articles_pkey on articles
(cost=0.42..462150.49 rows=3573 width=1298) (actual time=2.055..9.711
rows=10 loops=1)
         Filter: (article_text @@ '''in_index'''::tsquery)

   ->  Index Scan using articles_pkey on articles
(cost=0.42..462150.49 rows=3573 width=1298) (actual
time=5633.672..5633.672 rows=0 loops=1)
         Filter: (article_text @@ '''not_in_index'''::tsquery)