Re: [PERFORM] Index scan plan estimates way off.

Oops, forgot to CC my reply to the list. Sorry if this gets messed up. On Thu, Mar 5, 2009 at 12:30 PM, Tom Lane wrote: > Jonathan Hseu writes: > > Sort (cost=11684028.44..11761274.94 rows=30898601 width=40) > >Sort Key: "time" > >-> Bitmap H

[PERFORM] Index scan plan estimates way off.

ed setting random_page_cost=1, but it still gave me the bitmap plan. Thanks, Jonathan Hseu