Re: scheduler in core - Mailing list pgsql-hackers

From Greg Stark
Subject Re: scheduler in core
Date
Msg-id 407d949e1002201518l3234e960o52fb3d7e9b718a80@mail.gmail.com
Whole thread Raw
In response to Re: scheduler in core  (Dimitri Fontaine <dfontaine@hi-media.com>)
Responses Re: scheduler in core
List pgsql-hackers
On Sat, Feb 20, 2010 at 10:03 PM, Dimitri Fontaine
<dfontaine@hi-media.com> wrote:
> What would it take to have it included in core, so that it's not a
> separate install to do? I'd love to have some support for running my
> maintenance pl functions directly from the database. I mean without
> installing, running and monitoring another (set of) process.

It'll always be another (set of) processes even if it's "in core". All
it means to be "in core" is that it will be harder to make
modifications and you'll be tied to the Postgres release cycle.

> Main advantage over cron or another scheduler being that it'd be part of
> my transactional backups, of course.

All you need for that is to store the schedule in a database table.
This has nothing to do with where the scheduler code lives.



-- 
greg


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PGXS: REGRESS_OPTS=--load-language=plpgsql
Next
From: Tom Lane
Date:
Subject: Re: scheduler in core