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