Diskspace
jrwaving-ops
PROOP
6 days ago
PostgreSQL reports ~353 MB including WAL, but Railway volume usage is ~4.9 GB on a 5 GB Hobby volume. Can you explain exactly what contributes to the remaining ~4.5 GB? Does volume accounting include PITR snapshots/base backups/WAL retention outside pgdata?
2 Replies
Status changed to Open Railway • 6 days ago
balkar1998
FREE
6 days ago
pg_database_size() only shows logical database size, not total filesystem consumption on the Railway volume.
The missing ~4.5 GB is probably from:
pg_wal- retained WAL for PITR/replication
- temp files
- dead tuples/bloat
- snapshots/base backups
Can Railway confirm whether PITR snapshots/WAL archival are counted inside the mounted volume quota?
Check WAL usage:
SELECT pg_size_pretty(SUM(size))
FROM pg_ls_waldir();balkar1998
FREE
6 days ago
VACUUM FULL;
REINDEX DATABASE your_db;