Re: [GENERAL] Out of control query

2008-12-19 Thread Craig Ringer
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 wo

Re: [GENERAL] Out of control query

2008-12-19 Thread Joshua D. Drake
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

[GENERAL] Out of control query

2008-12-19 Thread Jason Long
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