Re: pgAgent question

On Thu, Dec 16, 2010 at 11:35 AM, Dmitry Mordovin <d(dot)mordovin(at)dwide(dot)com> wrote:
> On 12/16/2010 01:32 PM, Dave Page wrote:
>
> On Thu, Dec 16, 2010 at 11:29 AM, Dmitry Mordovin <d(dot)mordovin(at)dwide(dot)com>
> wrote:
>
> Hello!
>
> Excuse me, I'm not sure this pgadmin list allow pgagent question.
>
> Yes, it does.
>
> Is there any way to execute scheduled job often than every 1-2 minutes?
>
> No.
>
> Hi Dave!
>
> How about to add this in TODO list?
>
> May be, I can think about simple solution.

It would add a lot of extra complexity that noone (other than you)
that I can recall has asked for in the past. Also, if you need to
process something that frequently, then pgAgent probably isn't going
to be the best solution for you anyway, due to the way it polls the
jobs table to check for things to run. You would probably want
something that polls, caches and then executes all the tasks over the
next few minutes, before starting over.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company