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
Percy6mo ago
Project ID: 652b6038-5926-4167-a8fe-58e7d85c2888
Michael Li
Michael LiOP6mo ago
652b6038-5926-4167-a8fe-58e7d85c2888
Solution
Brody
Brody6mo 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