Hi, We have a roller instance 1.0 setup on our portal.
We have a pretty decent server machine with 2G ram and more than 3 GHz cpu running redhat linux. We have about 5000 roller accounts setup in the roller database on postgre db. The behavior we are seeing is that for every hit we get to anything related to the blog pages or the management pages, the postmaster (postgresql process) shoots up to > 95%! I am trying to figure out whats happening. All indexes on the roller database seem to be fine. And the postgresql install/setup script was executed correctly. The functionality is working except for the CPU problem. Few questions: - Is there a known problem regarding this? - will using mysql database instead of postgresql help? - will a later version help Would appreciate any solutions/hints I get to fix this .. thanks and regards, Trishul (http://desihub.com)
