On Sun, Jan 10, 2010 at 10:53 AM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > seq_page_cost = 0.1 > random_page_cost = 0.1 These might not even be low enough. The reason why bitmap index scans win over plain index scans, in general, is because you make one pass through the heap to get all the rows you need instead of bouncing around doing lots of random access. But of course if all the data is in RAM then this argument falls down. If these aren't enough to get the query planner to DTRT, then the OP might want to try lowering them further and seeing how low he has to go to flip the plan... ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
