Re: CPU Intensive query

> one of them has suddenly decided to get very slow

Is there a way to predict when the system will do this? Also, why would it suddenly go from IO intensive to CPU intensive.

Also, this query ran today and it already finished. Today it was IO intensive.

Please provide me some direction to this problem.

Thanks.

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
Abu Mushayeed writes:
> The query is as follows and it's explain plan is also attached:

The query itself seems to be a simple join over not too many rows, so
I don't see how it could be taking 24 hours. What I suspect is you're
incurring lots and lots of invocations of those user-written functions
and one of them has suddenly decided to get very slow.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

---------------------------------
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.