4 months ago
I cleared some records and run VACUUM FULL using terminal. When checking the database size using terminal using below command it returns: 8892 KB
SELECT pg_size_pretty(pg_database_size(current_database())) AS total_size;
But in volume metrics it still says 452MB. It’s been few hours since I cleared the records. It was previously about 152MB.
Total size of all databases also returns values less than 452MB in total.
Attachments
5 Replies
4 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
4 months ago
Dropped all the tables, but volume still uses around 50% capacity.
Attachments
4 months ago
Hello!
We've escalated your issue to our engineering team.
We aim to provide an update within 1 business day.
Please reply to this thread if you have any questions!
Status changed to Awaiting User Response Railway • 4 months ago
4 months ago
Postgres stores other data beyond just tables, such as transaction logs or WAL files. You can check this inside your container by running:
root@e8b8af64fd86:/# du -sh /var/lib/postgresql/data/pgdata/
329M /var/lib/postgresql/data/pgdata/Unfortunately this isn't something we can control. You may have cleared all tables, but Postgres itself may be using the space for other purposes.
4 months ago
✅ The ticket Data Volume Update Issue has been marked as completed.
ray-chen
Postgres stores other data beyond just tables, such as transaction logs or WAL files. You can check this inside your container by running:root@e8b8af64fd86:/# du -sh /var/lib/postgresql/data/pgdata/ 329M /var/lib/postgresql/data/pgdata/Unfortunately this isn't something we can control. You may have cleared all tables, but Postgres itself may be using the space for other purposes.
4 months ago
1 - What if I get a backup of the 'railway' database, and then wipe the volume and restore the backup via psql.
2- Also I see other databases as below, Are these tables contain any data of mine or is that just for internal infrastructure?
template1
postgress
tenplate0
3 - Also how to access the command you mentioned earlier?
Attachments
Status changed to Awaiting Railway Response Railway • 4 months ago
4 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 4 months ago