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
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
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