Regarding Bitmap Scan - Mailing list pgsql-performance

From soni de
Subject Regarding Bitmap Scan
Date
Msg-id 9f2e40a90610170439n4b670c23ld586e4f0840e943@mail.gmail.com
Whole thread Raw
Responses Re: Regarding Bitmap Scan
Re: Regarding Bitmap Scan
List pgsql-performance

Hello,

 

I was going through the Performance Enhancements of 8.1.0, in that I have read "Bitmap Scan"

 

"Bitmap Scan: indexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables. This also helps simplify database management by greatly reducing the need for multi-column indexes."

 

I didn't understand the "Bitmap Scan" and the sentence "indexes will be dynamically converted to bitmaps in memory". What does mean by "Bitmap Scan" in database?

 

Can anybody help us regarding above query?

 

Thanks,

Soni

pgsql-performance by date:

Previous
From: Ruben Rubio
Date:
Subject: Re: Optimization of this SQL sentence (SOLVED)
Next
From: "A. Kretschmer"
Date:
Subject: Re: Regarding Bitmap Scan