From: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Cc: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Subject: | Re: pgAgent question |
Date: | 2006-04-20 14:01:57 |
Message-ID: | 8511B4970E0D124898E973DF496F9B4357E0EB@stash.stackdump.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Yes.
PgAdmin/pgAgent and PostgreSQL ar running on the same box.
RUnning the stored procedure even from a remote pgAdmin at the console results in the same 16 second performance.
________________________________
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Thu 4/20/2006 1:17 AM
To: Benjamin Krajmalnik
Cc: pgadmin-support(at)postgresql(dot)org
Subject: RE: pgAgent question
> -----Original Message-----
> From: Benjamin Krajmalnik [mailto:kraj(at)illumen(dot)com]
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-04-20 15:35:55 | Re: pgAgent question |
Previous Message | Dave Page | 2006-04-20 07:17:42 | Re: pgAgent question |