by zedjr » Mon Jun 29, 2009 10:26 am
I am trying to tune postgres as good as i cna on the system i have. IS a high end system with 12gbs of 3 channel ddr3 1600 ram with 2 ssd fast hard drives in raid 0 with i7 intel cpu. It seems that my one problem with the hud speed is when over time it doesnt reload tables stats or it takes forever to do this. am pretty sure it has to be some setting somewhere i can adjust in postgresql conf or another file. I jstu dont know which one. I changed a few of recomended settings that pertained to hardware settigns in postgresql and this greatly improved this but still there is alot of lag that can be eliminated. so any thoughts of what this could be or what i can change please tell. thanks