Re: 4s query want to run faster

The other parameter you might want to look at is effective_cache_size -
increasing it will encourage index use. On a machine with 16GB the
default is probably too small (there are various recommendations about
how to set this ISTR either Scott M or Greg Smith had a page somewhere
that covered this quite well - guys?).

Obviously, decreasing random_page_cost fixed this query for you, but if
find yourself needing to tweak it again for other queries, then look at
changing effective_cache_size.

Cheers

Mark


Adonias Malosso wrote:
> Set random_page_cost = 2 solved the problem. thanks
>