Hi Dave, I was talking about the same functions on WIKI Regards Vaneet
-----Original Message----- From: Dave Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 3:00 PM To: [email protected] Subject: Re: Roller + postgresql ... cpu utilization problem 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. 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
