| From: | Jason Long <mailing(dot)list(at)supernovasoftware(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Out of control query |
| Date: | 2008-12-19 22:20:02 |
| Message-ID: | 494C1E12.5040405@supernovasoftware.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-12-19 22:30:51 | Re: Out of control query |
| Previous Message | Tom Lane | 2008-12-19 16:53:33 | Re: Question about inscrutable cast syntax |