Scott... slight change... and some info
Judging by what I have been watching, with debug mode turned on for PostGresQL, Postgres could use a bit more memory for sorts... on some of the big threads... I quadrupled its sort space... quadrupled the shared buffers also... set the nightly maintenance (vacuum and analyze) to do the best "analyze" for query optimizations and such.
Also, you should prolly include [link|http://www.iwethey.org/zope2logs/|Zope Stats] along with [link|http://www.iwethey.org/zlogs|Usage Stats]...
Just a change and a suggestion...
That's all!
b4k4^2
[link|mailto:curley95@attbi.com|greg] - Grand-Master Artist in IT |
[link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!] [link|http://pascal.rockford.com:8888/SSK@kQMsmc74S0Tw3KHQiRQmDem0gAIPAgM/edcurry/1//|ED'S GHOST SPEAKS!] |
[link|http://www.eweek.com/article2/0,3959,857673,00.asp|Writing on wall, Microsoft to develop apps for Linux by 2004] |
Heimatland Geheime Staatspolizei reminds: These [link|http://www.whitehouse.gov/pcipb/cyberspace_strategy.pdf|Civilian General Orders], please memorize them. "Questions" will be asked at safety checkpoints. |