From: | Christopher Browne <cbbrowne(at)gmail(dot)com> |
---|---|
To: | Artur Litwinowicz <admin(at)ybka(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: elegant and effective way for running jobs inside a database |
Date: | 2012-03-06 17:37:01 |
Message-ID: | CAFNqd5X3Ka0twi05AdeQzD-5oMCW864oA=SPzzeca=8gLk8+_A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Mar 6, 2012 at 12:20 PM, Artur Litwinowicz <admin(at)ybka(dot)com> wrote:
> Algorithm for first loop:
> check jobs exists and is time to run it
> run job as other sql statements (some validity check may be done)
> get next job
> no jobs - delay
There are crucial things missing here, namely the need to establish at
least one database connection in order to be able to check for the
existence of jobs, as well as to establish additional connections as
contexts in which to run jobs.
That implies the need for some New Stuff that isn't quite the same as
what we have within server processes today.
There is nothing horrible about this; just that there's some extra
mechanism that needs to come into existence in order to do this.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2012-03-06 17:44:19 | Re: Checksums, state of play |
Previous Message | Peter Eisentraut | 2012-03-06 17:30:28 | Re: WIP: URI connection string support for libpq |