BitMap Heap Scan & BitMap Index Scan

From: monalee_dba <monalee(at)sungraceinfotech(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: BitMap Heap Scan & BitMap Index Scan
Date: 2013-11-10 07:32:14
Message-ID: 1384068734255-5777632.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 thensome time
query planner uses Bitmap Heap Scan and some time Bitmap Index Scan?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BitMap-Heap-Scan-BitMap-Index-Scan-tp5777632.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message monalee_dba 2013-11-10 07:40:24 Order By Clause, Slows Query Performance?
Previous Message Kevin Grittner 2013-11-09 16:30:45 Re: Performance bug in prepared statement binding in 9.2?