On Aug 24, 2005, at 3:35 AM, Vaneet Sharma wrote:
when u set up postgres, in the documentation in the roller, they
recommend to add some functions.
may be they can help?
Can you elaborate?
I found some functions on this page:
http://www.rollerweblogger.org/wiki/Wiki.jsp?page=PostgreSQL
But they are a workaround for a bug that has been long since fixed and
should have no effect on performance.
- Dave
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.
