On Aug 20, 2005, at 9:22 PM, trishul s wrote:
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.
When we had problem with un-indexed columns, we had queries taking
longer than a second. Perhaps you could filter for queries > 500ms and
learn something more?
Unfortunately, I don't see anything obvious in your log file. The
categoryid field is indexed in the weblogcategoryassoc and weblogentry
tables, so it's not the problem.
- Dave
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
> (http://desihub.com)
<[EMAIL PROTECTED]><messages.txt>
