Re: pgAgent question

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Benjamin
Krajmalnik
Sent: 20 April 2006 15:02
To: pgadmin-support(at)postgresql(dot)org
Cc: Dave Page
Subject: Re: [pgadmin-support] pgAgent question


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.

I may well have to take this one off to another list as pgAgent simply
executes the query using libpq like pgAdmin (though it does so
synchronously iirc, whereas pgAdmin runs asynchronously and displays the
results as they come in).

Can you share the code in the job step(s), and the stored procedure?

Regards, Dave.