Re: Query Performance question

Magers, James, 14.07.2014 15:18:
> Thank you.  I executed the query this morning after disabling the scan types.
> I am including links to explain.depesz output for each of the three variations that I executed.
>
> indexscan and bitmapscan off: http://explain.depesz.com/s/sIx
> seqscan and bitmapscan off: http://explain.depesz.com/s/GfM
> bitmapscan off: http://explain.depesz.com/s/3wna
>

So the original query (using an "Index Scan" + "Bitmap Index Scan") is indeed the most efficient one: 4ms vs. 39ms vs.
64ms