From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Thu 4/20/2006 1:17 AM
To: Benjamin Krajmalnik
Cc: pgadmin-support@postgresql.org
Subject: RE: pgAgent question
> -----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.
