On 8/20/05 9:22 PM, "trishul s" <[EMAIL PROTECTED]> wrote:
> Hi Dave, > > Thanks. I have set the postgres to log queries longer than 50 ms. Attached > please find the long queries. Looks like a lot of queries with where clauses > for categoryid. Can I do anything to disable these queries. There are about > 17000 rows in the weblogcategory table. > > Please let me know if any configuration setting will help on postgres or if I > should disable some feature to reduce this. > > thanks > Trishul > > ---------------- > 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 Another dumb question: I want to convert newlines to <BR>s and I was trying to figure out if this needs to be done in the java or if this can be done in a template, and if it can, could someone point me out to where to go?
