Hmm... I use Postgres on one of my dev boxes, but I haven't used it in
production. Guess there are some kinks.
With MySQL there is a way to log all long queries, can you set
something up for Postgres like that? It would be nice to know which
queries are causing the CPU usage.
- Dave
On Aug 19, 2005, at 2:08 AM, trishul s wrote:
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)
