Re: planer chooses very bad plan

From: Corin <wakathane(at)gmail(dot)com>
To: Luke Lonergan <LLonergan(at)greenplum(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: planer chooses very bad plan
Date: 2010-04-11 22:44:01
Message-ID: 4BC250B1.5010301@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-04-11 22:49:49 Re: planer chooses very bad plan
Previous Message Corin 2010-04-11 22:41:19 Re: planer chooses very bad plan