1 Answer
- Newest
- Most votes
- Most comments
0
I would look into VACUUM: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Autovacuum.html. It is a PostgreSQL feature that cleans up space caused by deleted or updated rows.
As an example, you can try to run SQL query to see if your tables need vacuuming:
SELECT datname, age(datfrozenxid) FROM pg_database ORDER BY age(datfrozenxid) desc limit 20;
Relevant content
- Accepted Answerasked 9 months ago
- asked 10 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 years ago
I ran VACUUM FULL and it says 0 rows were updated.
I am suspecting that the problem is with temporary files, as I had the flag
remove_temp_files_after_crash
switched off by default, so a lot of garbage accumulated over time. Is there a way to clear those temporary files? I believe this is a managed DB so I can't access the files directly...