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

PostgreSQL table fahrplan too big #105

Open
martinheppner opened this issue Apr 24, 2024 · 0 comments
Open

PostgreSQL table fahrplan too big #105

martinheppner opened this issue Apr 24, 2024 · 0 comments
Assignees
Labels
cleanup Cleanup old code

Comments

@martinheppner
Copy link
Contributor

The provider blocked access to our PostgreSQL database, because it is using too much space on disk (> 30GB). The biggest table is "fahrplan". Can we reduce the size somehow?

On this page I found a select to show the biggest columns in the datrabse: https://stackoverflow.com/questions/18316893/how-to-estimate-the-size-of-one-column-in-a-postgres-table

@martinheppner martinheppner self-assigned this Apr 24, 2024
@martinheppner martinheppner added the cleanup Cleanup old code label Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
cleanup Cleanup old code
Projects
Status: Done
Development

No branches or pull requests

1 participant