On 4/17/12 2:49 AM, Istvan Endredy wrote:
> thanks for the suggestion, but it didn't help. We have tried it earlier.
This plan seems very odd -- doing individual index lookups on 2.8m rows
is not standard planner behavior. Can you confirm that all of your
other query cost parameters are the defaults?
PostgreSQL Experts Inc.
In response to
pgsql-performance by date
|Next:||From: Ants Aasma||Date: 2012-04-19 10:32:50|
|Subject: Re: bad planning with 75% effective_cache_size|
|Previous:||From: Josh Berkus||Date: 2012-04-19 00:09:29|
|Subject: Re: Linux machine aggressively clearing cache|