Re: 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 such as some types of text processing, calculations,
etc. I have quite a few CPU-bound queries in the system I'm working
with, and they cause no problems.

> I would think that other users would get a different core and one query
> could not deadlock the whole system for everyone.

That should indeed be the case. Are your other users completely unable
to run queries, or are they just too slow? Have you tested by connecting
with `psql' and running queries by hand? Have you checked the pg_locks
table to see if there's any possible locking issue preventing the other
users from proceeding with their queries? Is your disk subsystem also
working hard during these difficult queries?

--
Craig Ringer