>>> Robert Haas <robertmh...@gmail.com> wrote: > What's weird about this example is that when he sets enable_seqscan to > off, the bitmap index scan plan is actually substantially faster, even > though it in fact does scan nearly the entire heap. I don't > understand how it can be faster to scan the index and the heap than to > just scan the heap. It's cached in the second test, maybe? -Kevin
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
