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

On Mon, Mar 10, 2014 at 4:46 AM, Jeff Janes wrote: > > On Fri, Mar 7, 2014 at 6:46 PM, Mohan Krishnan wrote: >> >> Hello folks, >> >> I have a table of about 700k rows in Postgres 9.3.3, which has the >> following structure: >> >> Columns: >&g

[PERFORM] 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)