databasepostgresqlamazon-web-servicesamazon-rds
Postgres AWS RDS Database high load during random moments
My Postgres database is having a high load during random moments of the each day, and when I reboot it comes back to normal.
The performance insight below shows the queries, the problems that I can see are in DataFileRead e WALWriteLock.
The problema is that the same queries run all throughout the day without issues, but at random moments it spikes.
Below the graph of the last week:
Solution
I ended up changing the instance type of my RDS from a type with 4 vCPU to a type with 8 vCPU, changed from a xLarge to a 2xLarge, and it solved the problem.
My best guess is that maybe some processes were ocuppying all the CPUs and getting the other processes stuck, resulting in this high load, and when restarting the database it "unstuck" the processes.
- How to link pharmacies table with medicine table?
- PostgreSQL - dump each table into a different file
- Is there a way to EDIT databases (sqlite) in VSCode?
- postgresql: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
- How does "OR if Y is a prime attribute" eliminate redundancy for 3NF?
- What is the biggest ID number that autoincrement can produce in mysql
- Is multiple field index in MySQL a good choice?
- Restore a postgres backup file using the command line?
- MongoDB - Combining two collections without a foreign field matching
- Type error while looping through array in PL/pgSQL
- What is the difference between JOIN and UNION?
- Create a back-end database for iOS and web apps using filemaker
- How to convert a postgres database to SQLite?
- any way to set screen options wordpress via the database?
- Is there a simple way to get SQL Workbench to only focus on one database?
- How to build a relationship between a 'user' and 'his comment'?
- Database tables that seem like they "ought to" violate 4NF, but don't
- Rails ActiveAdmin Eliminating n+1 queries on custom attributes belong to another model
- Some sort of “different auto-increment indexes” per a primary key values
- Why is read repair not sufficient in making dynamo-style database linearizable?
- Alternatives to Northwind
- Query to list number of records in each table in a database
- Notion API - Notion database model is also a block?
- How Milvus work when search with expr and vector?
- Room - Schema export directory is not provided to the annotation processor so we cannot export the schema
- psql warning: extra command-line argument x ignored when using Connection URIs
- Are there any difference between data integrity and data consistency?
- How to generate SQLite entity relationship diagram from database file
- Copying CSV to PostgreSQL database using Psycopg3 in Python
- Why do we need another level of [] when using character classes?