Re: Postgres not willing to use an index? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Postgres not willing to use an index?
Date
Msg-id 498C21D8.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Postgres not willing to use an index?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Postgres not willing to use an index?
List pgsql-performance
>>> Robert Haas <robertmhaas@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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Next
From: Arjen van der Meijden
Date:
Subject: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller