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 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] 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 buffe

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 actu

Re: [PERFORM] planner index choice

2010-07-29 Thread Chris
Hi, Hrm ... are you *certain* that's an 8.4 server? Yep. # psql -U postgres -d db psql (8.4.4) db=# select version(); version --