Re: [PERFORM] planner index choice

2010-07-29 Thread tv
http://explain.depesz.com/s/br9 http://explain.depesz.com/s/gxH Well, I don't have time to do a thorough analysis right now, but in all the plans you've posted there are quite high values in the Rows x column (e.g. the 5727.5 value). That means a significant difference in estimated and actual

Re: [PERFORM] Testing Sandforce SSD

2010-07-29 Thread Michael Stone
On Wed, Jul 28, 2010 at 03:45:23PM +0200, Yeb Havinga wrote: Due to the LBA remapping of the SSD, I'm not sure of putting files that are sequentially written in a different partition (together with e.g. tables) would make a difference: in the end the SSD will have a set new blocks in it's

Re: [PERFORM] planner index choice

2010-07-29 Thread Tom Lane
t...@fuzzy.cz writes: http://explain.depesz.com/s/br9 http://explain.depesz.com/s/gxH Well, I don't have time to do a thorough analysis right now, but in all the plans you've posted there are quite high values in the Rows x column (e.g. the 5727.5 value). That means a significant

Re: [PERFORM] Pooling in Core WAS: Need help in performance tuning.

2010-07-29 Thread Josh Berkus
introduce bugs. If we can get to the point where we have something to play around with, even if it's kind of kludgey or doesn't quite work, it'll give us some idea of whether further effort is worthwhile and how it should be directed. Should I put this on the TODO list, then, in hopes that