Add 'skip_queuing' column to cron.job table
- Dominant language
- C
- Stars
- 3.9k
- Forks
- 260
- Avg merge
- 5d 5h
- Merged PRs (30d)
- 1
Description
Dear pg_cron team,
I'd like to discuss the addition of the ability to control job queuing when the same job is already running.
I use stored procedures to ensure retention on high volume tables. Those procedures are aimed to delete and update records older than a given date in several tables.
Due to the variance in the amount of rows to delete, the run time of those jobs is highly volatile.
Currently they are triggered by the linux cron daemon every minute and we use the `flock` command to avoid concurrent execution with the `-n` flag to skip execution.
I want to migrate those jobs to pg_cron, but pg_cron currently queues all jobs when the same job is already running.
Could you please consider the addition of a boolean flag in the cron.job table to control that behavior ?
Best regards
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.