Re: How to run a task continuously in the background

pg_cron, perhaps?
https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/

I _think_ it ticks all three of your boxes.

I also checked pg_cron, but this has the disadvantage that it allows starting a job at most once a minute. On the other hand, the job runs as long as there are records to process. And during this time nothing should be queued again.

DIrk