Re: pgAgent question

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: pgAgent question
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9E0C@ratbert.vale-housing.co.uk
обсуждение исходный текст
Список pgadmin-support
 


From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
Sent: 20 April 2006 15:02
To: pgadmin-support@postgresql.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.

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: pgAgent question
Следующее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: pgAgent question