I would like to know, What is BitMap Heap Scan & BitMap Index Scan? When I use EXPLAIN for query, which has LEFT JOIN with 4 different table then some time query planner uses Bitmap Heap Scan and some time Bitmap Index Scan? View this message in context: BitMap Heap Scan & BitMap Index Scan Sent from the PostgreSQL - performance mailing list archive at Nabble.com.