Re: elegant and effective way for running jobs inside a database - Mailing list pgsql-hackers

From Christopher Browne
Subject Re: elegant and effective way for running jobs inside a database
Date
Msg-id CAFNqd5X3Ka0twi05AdeQzD-5oMCW864oA=SPzzeca=8gLk8+_A@mail.gmail.com
Whole thread Raw
In response to Re: elegant and effective way for running jobs inside a database  (Artur Litwinowicz <admin@ybka.com>)
Responses Re: elegant and effective way for running jobs inside a database  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, Mar 6, 2012 at 12:20 PM, Artur Litwinowicz <admin@ybka.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?"


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: WIP: URI connection string support for libpq
Next
From: Robert Haas
Date:
Subject: Re: Checksums, state of play