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
Solution:Jump to 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
3 Replies
Project ID:
652b6038-5926-4167-a8fe-58e7d85c2888
652b6038-5926-4167-a8fe-58e7d85c2888
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