From: Abu Mushayeed <abumushayeed@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: CPU Intensive query
Date: Fri, 18 May 2007 15:26:08 -0700 (PDT)
Message-ID: <268362.88510.qm@web57106.mail.re3.yahoo.com> (raw)
In-Reply-To: <3287.1179525064@sss.pgh.pa.us>
> 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@sss.pgh.pa.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: abumushayeed@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: CPU Intensive query
In-Reply-To: <268362.88510.qm@web57106.mail.re3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox