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

2014-03-07 Thread Mohan Krishnan
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)

Re: [PERFORM] Query taking long time

2014-03-07 Thread acanada
El Mar 7, 2014, a las 11:03 AM, Evgeniy Shishkin escribió: > > On 07 Mar 2014, at 12:46, acanada wrote: > >> >> El Mar 7, 2014, a las 10:39 AM, Evgeniy Shishkin escribió: >> >>> Hello Mat, Setting enable_bitmapscan to off doesn't really helps. It gets worse... x=>

Re: [PERFORM] Query taking long time

2014-03-07 Thread Evgeniy Shishkin
On 07 Mar 2014, at 12:46, acanada wrote: > > El Mar 7, 2014, a las 10:39 AM, Evgeniy Shishkin escribió: > >> >>> Hello Mat, >>> >>> Setting enable_bitmapscan to off doesn't really helps. It gets worse... >>> >>> x=> SET enable_bitmapscan=off; >>> SET >>> x=> explain analyze select * from (

Re: [PERFORM] Query taking long time

2014-03-07 Thread acanada
El Mar 7, 2014, a las 10:39 AM, Evgeniy Shishkin escribió: > >> Hello Mat, >> >> Setting enable_bitmapscan to off doesn't really helps. It gets worse... >> >> x=> SET enable_bitmapscan=off; >> SET >> x=> explain analyze select * from (select * from entity2document2 where >> name='ranitidine

Re: [PERFORM] Query taking long time

2014-03-07 Thread Evgeniy Shishkin
> Hello Mat, > > Setting enable_bitmapscan to off doesn't really helps. It gets worse... > > x=> SET enable_bitmapscan=off; > SET > x=> explain analyze select * from (select * from entity2document2 where > name='ranitidine' ) as a order by a.hepval; >