Re: [PERFORM] bad planning with 75% effective_cache_size

2012-04-19 Thread Istvan Endredy
Hi everybody, thanks for the so many responses. :) > On Thu, Apr 19, 2012 at 3:44 AM, Josh Berkus >>> 7500ms >>> http://explain.depesz.com/s/ >> 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 >> othe

Re: [PERFORM] bad planning with 75% effective_cache_size

2012-04-19 Thread Ants Aasma
On Thu, Apr 19, 2012 at 3:44 AM, Josh Berkus >> 7500ms >> http://explain.depesz.com/s/ > 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? This similat to th