Re: [PERFORM] BitMap Heap Scan & BitMap Index Scan

On 10/11/13 08:32, monalee_dba wrote: > 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? Check out this great presen

Re: [PERFORM] BitMap Heap Scan & BitMap Index Scan

http://www.postgresql.org/docs/9.3/static/using-explain.html On Sun, Nov 10, 2013 at 4:32 PM, monalee_dba wrote: > 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 Bit

[PERFORM] BitMap Heap Scan & BitMap Index Scan

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