Kim Hansen <kim(at)rthansen(dot)dk> wrote:
> I have a query where the planner makes a wrong cost estimate, it
> looks like it underestimates the cost of a "Bitmap Heap Scan"
> compared to an "Index Scan".
> What can I do to fix the cost estimate?
Could you try running the query with cpu_tuple_cost = 0.05 and let
us know how that goes?
In response to
pgsql-performance by date
|Next:||From: Gregg Jaskiewicz||Date: 2012-04-05 15:39:26|
|Subject: heavly load system spec|
|Previous:||From: Kevin Grittner||Date: 2012-04-05 15:01:25|
|Subject: Re: about multiprocessingmassdata|