search

bahnzumberg / zuugle-api

Public repositority for backend components of www.zuugle.at
https://www.zuugle.at
GNU General Public License v3.0
2 stars 3 forks source link

PostgreSQL table fahrplan too big #105

Closed martinheppner closed 1 month ago

martinheppner commented 2 months ago

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 commented 1 month ago

Some unused columns and indices have been removed