On Thu, 2005-01-13 at 12:14 +1300, Mark Kirkwood wrote:
[snip some explains]
>
> I have random_page_cost = 0.8 in my postgresql.conf. Setting it back to
> the default (4) results in a plan using test_id1.
it is not rational to have random_page_cost < 1.
if you see improvement with such a setting, it is as likely that
something else is wrong, such as higher statistic targets needed,
or a much too low effective_cache setting.
gnari