[GENERAL] Out of control query

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

Re: [GENERAL] Out of control query

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

Re: [GENERAL] Out of control query

Jason Long wrote: For some reason the search gets out of control and consumes all CPU. [snip] What seems strange to me is that one one core of my Quad core x5472 is 100%. The others show minimal usage. Consuming all of one CPU is quite normal if a query requires a lot of CPU-intensive work