From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Jason Long <mailing(dot)list(at)supernovasoftware(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Out of control query |
Date: | 2008-12-19 22:30:51 |
Message-ID: | 1229725851.27840.9.camel@jd-laptop.pragmaticzealot.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2008-12-19 at 16:20 -0600, Jason Long wrote:
> I have an inventory system based on PostgreSQL 8.3.5, JBoss,
> Hibernate......
>
> I have a query builder that lets users filter data in a fairly complex
> way.
>
> For some reason the search gets out of control and consumes all CPU.
>
> I set my statement timeout to 2 minutes and this keeps the system from
> going down totally, but this is happening much more frequently than it
> used to.
>
> I can find the problem with the individual query easily enough, but I
> would like a more general solution.
>
> What seems strange to me is that one one core of my Quad core x5472 is
> 100%. The others show minimal usage.
>
> I would think that other users would get a different core and one
> query could not deadlock the whole system for everyone.
>
> Do you think this is due to my Postgres or JBoss AS configuration for
> database connections?
>
> Any advice will be greatly appreciated.
An explain analyze of the query would be useful.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2008-12-20 03:19:02 | Re: Out of control query |
Previous Message | Jason Long | 2008-12-19 22:20:02 | Out of control query |