Re: scheduler in core - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: scheduler in core
Date
Msg-id m2r5of36qq.fsf@hi-media.com
Whole thread Raw
In response to Re: scheduler in core  (Dave Page <dpage@pgadmin.org>)
Responses Re: scheduler in core
Re: scheduler in core
Re: scheduler in core
List pgsql-hackers
Dave Page <dpage@pgadmin.org> writes:
> Why not just use pgAgent? It's far more flexible than the design
> you've suggested, and already exists.

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.

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

Use cases, in case it's needed already, include creating new partitions,
materializing views at known intervals, more general maintenance like
vacuum and clusters operations, some reporting that could be done in the
database itself, etc.

Regards,
-- 
dim


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: PGXS: REGRESS_OPTS=--load-language=plpgsql
Next
From: Pavel Stehule
Date:
Subject: Re: scheduler in core