hello trishul,
when u set up postgres, in the documentation in the roller, they recommend to
add some functions.
may be they can help?
check the blogs i set up.
My blog is working fine. I am running on centos 4.0 with postgresql and tomcat
5.5.4
http://www.ballantinemanor.com/blog
regards
vaneet
-----Original Message-----
From: Dave Johnson [mailto:[EMAIL PROTECTED]
Sent: Fri 8/19/2005 3:00 PM
To: [email protected]
Cc:
Subject: Re: Roller + postgresql ... cpu utilization problem
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)
Vaneet Sharma
executive manager
iDeasTank Limited
an iwg business
dolphins' court po 388
valletta, m-malta/europe
mobile: +356 9943 8263
skype: CALLVANEET
fax: +356 9952 8888
phone: +356 9942 8888
[EMAIL PROTECTED]
call me on www.skype.com - my ID is CALLVANEET
Want a signature like this? - www.plaxo.com\signature
iwg is a global e-mobile company creating, building and growing new businesses.
iwg founders are pioneers in creating multi-billion dollar mobile and Internet
businesses in Europe, Asia and the US.
www.iWG.info
www.countryprofiler.com/iWG
www.visitmalta.com
www.mfc.com.mt
Privileged/Confidential Information may be contained in this message. If you
are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and kindly notify the
sender by reply email.
