On Sun, Apr 11, 2010 at 3:12 PM, Corin <wakathane(at)gmail(dot)com> wrote:
> I'm having a query where the planer chooses a very bad plan.
In both instances your number of rows estimated is WAY higher than the
actual number of rows returned. Perhaps if you increased
default_statistics_target to 100, 200, 500 etc. re-analyzed, and then
reun explain analyze again.
Also increasing work_mem might encourage the bitmap index scans to occur.
In response to
pgsql-performance by date
|Next:||From: Luke Lonergan||Date: 2010-04-11 21:22:33|
|Subject: Re: planer chooses very bad plan|
|Previous:||From: Corin||Date: 2010-04-11 21:12:30|
|Subject: planer chooses very bad plan|