Feature Request: Add Job Priority Support in pg_cron

[avamingli]

Hi, all

We've been using pg_cron extensively, and it has been working great - thank you for this excellent tool.

As our usage has grown, we've encountered situations where we'd like to prioritize certain jobs when running with limited background worker processes. This would be particularly useful when managing numerous scheduled tasks where some jobs are more important than others.

I understand implementing job priorities would require careful consideration around:

• Scheduling algorithms
• Fairness to prevent job starvation
• and more..

Before diving into implementation details, I wanted to check if there are any existing plans or discussions around this feature? I'd be happy to contribute thoughts or help with development if this aligns with pg_cron's roadmap.

Looking forward to hearing your thoughts.