John Siracusa <siracusa(at)mindspring(dot)com> writes:
> I want to do something that will convince Postgres that using the date
> index is, by far, the best plan when running my queries, even when the
> date column correlation stat drops well below 1.0.
Have you tried experimenting with random_page_cost? Seems like your
results suggest that you need to lower it.
regards, tom lane