Horton

Re: Proposal: Job Scheduler

Adam Brusselback <adambrusselback@gmail.com>

View thread
From: Adam Brusselback <adambrusselback@gmail.com>
To: Nikolay Samokhvalov <nik@postgres.ai>
Cc: Andrei Lepikhov <lepihov@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Dave Page <dpage@pgadmin.org>, Dmitry Dolgov <9erthalion6@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Wang Cheng <348448708@qq.com>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-05-30T14:24:02Z
Lists: pgsql-hackers 
Add me to the +1 for having a built-in scheduler. It's useful for plenty of
things like automated partition creation (as noted), scheduling backups,
index maintenance, batch processing jobs, etc...

I wrote jpgAgent (compatible with pgAgent) ~10 years ago because pgAgent
was too unstable (and the other scheduling tools hadn't come out yet), but
I really wish I didn't have to deal with external tooling for features like
this at all.