En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

In Postgres RDS my tables take around 500MB, but it says I am using 17GB?

0

Why does it say I am using so much more space?

I did a bit of searching, and it might be the temporary files. Can you tell me how to clear them? I haven't found a way to connect to RDS to view or clear those files.

Sujets
Base de donnéesMigration et modernisationAnalytique
Balises
PostgreSQLAmazon Relational Database ServiceBase de données
Langue
English
rePost-User-6685172
demandé il y a un an247 vues
1 réponse
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;

profile picture
EXPERT
Antonio_Lagrotteria
répondu il y a un an
  • rePost-User-6685172
    il y a un an

    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...

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents