postgresqlamazon-web-servicesamazon-rds
AWS Postgres RDS Disk Usage Spikes. Free disk space randomly goes down to 0
AWS Postgres RDS Disk Usage Spikes. The Free disk space randomly goes down to 0.
We have run out of possible answers for this, initially we thought this was due to MVCC and vacuum, but our table sizes are < 10 GB, and there are < 20 tables.
What can be the other causes of such spikes?
Solution
After a long time I was able to figure it out from this post - https://repost.aws/knowledge-center/diskfull-error-rds-postgresql
TLDR; It was because of Replication slots + Logical replication.
If you set the rds.logical_replication parameter value to 1, then AWS RDS sets the wal_level, max_wal_senders, max_replication_slots, and max_connections parameters. Changing these parameters can increase WAL generation.
- PostgreSQL trigger not working - neither BEFORE nor AFTER DELETE
- How to use serial with drizzle orm postgres?
- Create a dev database with same table structure as production in Postgres 9.3
- How to get records based on distance
- Any halfway decent jdbc wrappers for Scala?
- Select count query very slow on cold cache
- How could call a psql command from Python script
- Useing ANSI driver to connect to a postgreSQL DB with python psycopg2
- show top 10 occurring values in column
- Django ORM model default not applying in python queryset
- Only show users that having cars more than one
- How to add an auto-incrementing primary key to an existing table in PostgreSQL?
- How to estimate the size of one column in a Postgres table?
- Pentaho Data Integration 9.3 - Postgres Incremental load
- Docker - Postgres and pgAdmin 4 : Connection refused
- inserting values in database from sentiment analysis
- Scripts in the /docker-entrypoint-initdb.d folder are ignored
- How to solve asyncpg.exceptions.InvalidAuthorizationSpecificationError
- PostGIS Error: type "geography" does not exist
- Insert data into postgreSQL using nodejs typescript
- psql: FATAL: Peer authentication failed for user "dev"
- What is the default password for Postgres
- How to extract timestamp from UUID v7?
- Empty array as PostgreSQL array column default value
- How to list table foreign keys
- Using function result in WHERE clause in PostgreSQL
- Is it possible to autoformat / beautify SQL queries using pgAdmin4?
- INSERT rows that were missing for the UPDATE
- Insert into postgres SQL
- How do I decrypt data originally encrypted with `pgp_pub_encrypt` with the `gpg` command line?