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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster