Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

schedule_in_database function wastes sequence values #358

Open
caseyandgina opened this issue Sep 26, 2024 · 0 comments
Open

schedule_in_database function wastes sequence values #358

caseyandgina opened this issue Sep 26, 2024 · 0 comments

Comments

@caseyandgina
Copy link

I'm setting up some pg_cron jobs using Ansible, and was hoping to just call the schedule_in_database function on each deployment, as this will not create a job that already exists. However, I discovered that it does consume a value from the jobid_seq sequence even when it does not insert a new row, which is suboptimal as that will mean that my deployment scripts burn through a lot of sequence values unnecessarily. The column is a 64-bit integer which seems really overkill but should prevent this from becoming an actual problem in practice, but it would still be nice if it didn't consume sequence values unnecessarily.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant