On Wed, Jul 25, 2007 at 09:21:56AM -0400, Tim Mattison wrote: > By decibel at decibel: > - What version of PostgreSQL are you using? I'm somewhat surprised that > - it's not doing any bitmap scans. > > I'm running 8.0.13. I'm not too familiar with bitmap scans. What > queries in the system (aside from the one I was looking at) should be > using them?
Generally, they're used when you could utilize multiple indexes for a single query. But I think they first appeared in 8.1. BTW, most folks got a 60-70% performance boost from 8.0 to 8.2. -- Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828
pgpBsOFwQnLIr.pgp
Description: PGP signature
_______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
