Re: elegant and effective way for running jobs inside a database

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Christopher Browne <cbbrowne(at)gmail(dot)com>, Artur Litwinowicz <admin(at)ybka(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: elegant and effective way for running jobs inside a database
Date: 2012-03-09 15:55:27
Message-ID: CAHyXU0zj0MVDpPeW2kjWbkvacW8OqzjxfkaJn_Xta-NCJ+mKsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 9, 2012 at 9:36 AM, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp> wrote:
> 2012/3/6 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
>> It seems to me that the only thing that needs core support is the
>> ability to start up the daemon when postmaster is ready to accept
>> queries, and shut the daemon down when postmaster kills backends (either
>> because one crashed, or because it's shutting down).
>>
> So, although my motivation is not something like Cron in core,
> it seems to me Alvaro's idea is quite desirable and reasonable,
> to be discussed in v9.3.

100% agree (having re-read the thread and Alvaro's idea having sunk
in). Being able to set up daemon processes side by side with the
postmaster would fit the bill nicely. It's pretty interesting to
think of all the places you could go with it.

merlin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2012-03-09 16:33:36 Re: pg_upgrade and umask
Previous Message Jeff Janes 2012-03-09 15:53:22 Re: pg_prewarm