On Fri, Feb 6, 2009 at 12:41 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: >>>> 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?
I gather that the results were repeatable, but perhaps Mario could double-check that? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance