From: Corin <wakathane@gmail.com>
To: Luke Lonergan <LLonergan@greenplum.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: planer chooses very bad plan
Date: Mon, 12 Apr 2010 00:44:01 +0200
Message-ID: <4BC250B1.5010301@gmail.com> (raw)
In-Reply-To: <2106D8DC89010842BABA5CD03FEA4061016617EAF9@EXVMBX018-10.exch018.msoutlookonline.net>
References: <2106D8DC89010842BABA5CD03FEA4061016617EAF9@EXVMBX018-10.exch018.msoutlookonline.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wakathane@gmail.com, LLonergan@greenplum.com
Subject: Re: planer chooses very bad plan
In-Reply-To: <4BC250B1.5010301@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox