citusdata / citusdata/pg_cron

Add 'skip_queuing' column to cron.job table

Open
#79 3 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.