It
takes about the same time.
Since
I do not need statistics on every single test (some of them have data that is
not suited for statistical analysis), I modified my schema
slightly.
Each
test which has to be processed for statistics is tagged as such, reducing the
amount of data processed.
With
our current data set it went down to from about 30 seconds of execution time to
about 2 seconds.
Running this new procedure from pgAdmin and psql yielded approximately
the same results (about 2 seconds).
I
restarted the pgagent service, and with the new stored procedure it is taking
the same amount of time as with direct calls from pgadmin or
psql.
So, it
appears this was somehow a fluke - go figure. I will monitor this, and if
I come across the issue again I will repost.
As
always, Thanks for your help.
Regads,
Benjamin
-----Original Message-----
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:10 PM
To: Benjamin Krajmalnik; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] pgAgent question
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:10 PM
To: Benjamin Krajmalnik; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] pgAgent question
That looks straightforward
enough - how quickly does it run in psql? That uses PQexec like pgAgent, unlike
pgAdmin which uses PQsendQuery (asynchronously)?
Regards,
Dave.
