How to reclaim postgres disk size?

This might not be a railway issue, but I noticed that my database disk space is not reclaimed even after run vacuum full for whole database. My database is really small, about 3k rows, but it occupies 1GB of disk space. I already run VACUUM FULL for each table. Any help will be appreciated. SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE('railway')); returns 11 MB
No description
No description
Solution:
this wouldn’t be a railway issue, i was able to create files on the volume, see the usage rise, delete the files, and see the usage drop back to the original value
No description
Jump to solution
3 Replies
Percy
Percy4w ago
Project ID: 652b6038-5926-4167-a8fe-58e7d85c2888
Michael Li
Michael Li4w ago
652b6038-5926-4167-a8fe-58e7d85c2888
Solution
Brody
Brody4w ago
this wouldn’t be a railway issue, i was able to create files on the volume, see the usage rise, delete the files, and see the usage drop back to the original value
No description
Want results from more Discord servers?
Add your server
More Posts
Clicking "Create Template" loads for a second and then stops and nothing happened.Just shows the circle for a few seconds and then it stops and gives no indicator that a template wasPackage not found though I am importing itI am getting the below error ```railway `rapidocr-onnxruntime` package not found, please install itCannot install with "frozen-lockfile" because pnpm-lock.yaml is absentTried deleting node modules and reinstalling as instructed in other threads along with deleting lockKuma health checks fail frequentlyRecently put up a Kuma service up to monitor two of my services (Bun backend & React frontend with CPuppeteer HangsHi! I have Pupeteer up and running with node on railway, but for some reason, my job just hangs whenHelp deploying Dockerfile of Elysia server to Railwayhave Dockerfile here: https://github.com/nikitavoloboev/drophunt/blob/main/api/Dockerfile not sure Getting a postgres error I don't recogniseGetting these from time to time, is it bad? Any tips to investigate or fix? ``` 2024-06-12 15:28:31.MongoDB Service Interruption Due to pthread_create FailureOur MongoDB instance is encountering repeated failures related to the creation of new threads. This Is a self-hosted mail service possible to host on Railway?Basically the title. Is it feasible to do this on Railway or should I try to do it elsewhere? I was We need serious help to continue using railway. Server is halting often and we are not sure why.Every so often we see "Application Failed to Respond". There is no log about a crash or fail in ra