AWS RDS Disk Usage Discrepancy with PgAdmin Statistics

amazon-rdspostgresql

I am using AWS RDS to host one PostgreSQL database. I notice that the disk usage at the AWS dashboard is much more (2x) than what is shown at PgAdmin. Hopefully someone can help me to figure out it.

AWS

PgAdmin

I find this issue after I tried several times to create a materialized view for caching very complex query results. All failed because of out of space (for computing?). I expect the remaining space (~7GB originally) would return but it didn't!!

Best Answer

It seems to be a lot of junk produced by the failed operations. A vacuum fix this issue.

Related Solutions

Postgresql – Postgres to Postgres DBLink with AWS/RDS

You need to configure the remote server so that it demands a password when logging on as foouser to mwu. Right now it is using one of the other authentication methods.

Sql-server – How to maintain Index and Statistics on AWS RDS

I am running SQL Server RDS maintenance jobs (DBCC CHECKDB, index reorgs/rebuilds, statistics updates) without a problem. The only limitation I had to work around was that I could not run sp_updatestats, so instead had to generate an 'UPDATE STATISTICS' script for each table like this:

DECLARE @sql NVARCHAR(max) = '';
SELECT @sql = @sql+
'UPDATE STATISTICS ' + '[' + table_name + ']' + ' WITH FULLSCAN;
PRINT ''UPDATING STATISTICS ON ' + table_name +'...'';
' 
FROM information_schema.tables
where TABLE_TYPE = 'BASE TABLE';

EXEC sp_executesql @statement=@sql;

Best Answer

Related Solutions

Postgresql – Postgres to Postgres DBLink with AWS/RDS

Sql-server – How to maintain Index and Statistics on AWS RDS

Related Question