Skip to content

Prune template_versions and provisioner_job_logs table #6020

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.

Sign up for GitHub

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

Jump to bottom
Closed
johnstcn opened this issue Feb 3, 2023 · 4 comments
Closed

Prune template_versions and provisioner_job_logs table #6020

johnstcn opened this issue Feb 3, 2023 · 4 comments
Labels
stale This issue is like stale bread.

Comments

@johnstcn
Copy link
Member

johnstcn commented Feb 3, 2023 •
edited
Loading

Problem

We currently don't prune the template_versions table or the provisioner_job_logs table.
When you do a template import dry-run, this creates a template versions and the logs also stick around.
This will eventually blow up the table sizes.

Solution

We need to implement some sort of time-based cleanup on these tables, pruning entries older than some value.
@github-actions
Copy link

github-actions bot commented May 5, 2023

This issue is becoming stale. In order to keep the tracker readable and actionable, I'm going close to this issue in 7 days if there isn't more activity.

@github-actions github-actions bot added the stale This issue is like stale bread. label May 5, 2023
@johnstcn johnstcn removed the stale This issue is like stale bread. label May 5, 2023
@johnstcn
Copy link
Member Author

johnstcn commented May 5, 2023

bump

@matifali
Copy link
Member

matifali commented May 5, 2023

Yes, indeed, Heroku's PostgreSQL instances are charged by the number of rows and we should not waste any table rows.

@matifali matifali added the chore label May 10, 2023
@bpmct
Copy link
Member

bpmct commented Sep 3, 2023

Related #9478

@github-actions github-actions bot added the stale This issue is like stale bread. label Mar 3, 2024
@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Mar 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
stale This issue is like stale bread.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@johnstcn @matifali @bpmct