Re: pgAgent question

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

Title: 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.