Re: Postgres Optimizer is not smart enough?

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