am Tue, dem 17.10.2006, um 17:09:29 +0530 mailte soni de folgendes: > 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?
For instance, you have a large table with 5 indexes on this and a query that checks conditions on this 5 columns. PG is now able to combine this 5 indexes and performs only 1 bitmap index scan on this table, and not 5 independet nested bitmap scans. A realy very great performance-boost! HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
