> -----Original Message----- > From: Benjamin Krajmalnik [mailto:[EMAIL PROTECTED] > Sent: 19 April 2006 20:23 > To: Dave Page > Subject: pgAgent question > > Hi Dave, > > I have a quick question. > I have a stored procedure which we use to calculate > statistics against each test for the past 30 days. > When I execute the stored procedure from the SQL editor in > pgAdmin it takes it about 16 seconds to run. > When it runs scheduled from pgAgent, it is showing a durtion > of about 87 minutes. > > Any ideas what is causing such a disparate result? > I have ran multiple exeutions to see if any one of them is a > fluke, but no. Every test which I run form pgAdmin is in the > 15-17 sec range while every executio from pgAgent is in the > 85 minute range.
Hi Benjamin, Please mail support issues to the mailing list rather than private email so others can help or benefit from any solutions found. This is certainly a strange issue considering the work of a stored procedure is all done on the server. Are you running pgAdmin and pgAgent on the same box? Where's PostgreSQL running? Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
