Re: planer chooses very bad plan - Mailing list pgsql-performance

On 11.04.2010 23:22, Luke Lonergan wrote:
> Try random_page_cost=100
>
Increasing random_page_const to 100 (it was 2.5 before) did not help,
but lowering it <=1.5 helped.

As almost the whole dataset fit's into memory, I think I'll change it
permanently to 1.5 (seq_page is 1.0).

I'll also increase the default_statistics to 1000, because this also
seems to help a lot.

Thanks,
Corin