Postgres Disk usage continuously increasing

Hi there,

I could suggest trying to narrow down which database and tables are using most of the disk space. You could use the following queries:

• Check the size of a specific database:

SELECT pg_size_pretty(pg_database_size('defaultdb'));

• Check the size of a specific table:

SELECT pg_size_pretty( pg_total_relation_size('table_name_here') );

In addition to what has already been mentioned, you can now add scalable storage to managed database clusters as shown in this video here:

Best,

Bobby

I’m facing the same challenge as well. Database gets maxxed out with little to no writes

Hi @eatingceruleaneel,

Is it possible that you are writing data to your Postgresql from your application? There isn’t anything else that I can think of to be honest.

If this continuous, however, I’ll recommend contacting DigitalOcean’s Support, they can provide you with more information as they would have access to your instance.