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
