Should I Worry About High Memory Alerts in My UAT Aurora PostgreSQL?
I have an Aurora PostgreSQL instance running with a DB.r6g.2xl size in production and a DB.r6g.large for the UAT environment. Recently, I've noticed a 'High Severity' warning on…
Aurora
Connection Issues with Aurora Postgres After Upgrading to Version 17
I recently upgraded my Aurora Postgres DB from version 13 to 17 because version 13 is reaching its end of life. The upgrade process went smoothly and my…
Is Building a Custom Tool for AWS Database Log Analysis Worth It?
Hey everyone! We're currently using Aurora with PostgreSQL and MySQL databases, and one of my teammates is considering developing a Python tool for log analysis. This tool would…
How to Fix High CPU Usage with a Complex Select Query in PostgreSQL?
I'm working with an Aurora PostgreSQL database (R6g.Large, version 17) that includes several transaction tables (like txn_tbl, txn_status, txn_decision, txn_sale, and ath), each containing around 2 million rows,…
How to Optimize Query Performance in Aurora Postgres?
I'm using Aurora Postgres version 17 and I'm experiencing some performance issues with one of my queries. I've shared the execution plan [here](https://gist.github.com/databasetech0073/344df46c328e02b98961fab0cd221492). 1. After creating an index…
Best Solutions for Storing and Searching Large Data Sets
Hey everyone! I'm looking for recommendations on how to store and efficiently search across a vast amount of data. We've got a flattened table structure with around 300…
How to Log Queries Without Exposing Sensitive Data in AWS Aurora?
Hey everyone, I'm looking for advice on logging performance queries for AWS Aurora databases, especially in contexts involving sensitive information, like personal or payment card data. I usually…
Is Aurora a Good Choice for Linux Beginners?
Hey everyone! I'm relatively new to using Linux, and I'm trying to decide whether to choose Fedora or Aurora as my first distribution. I know Aurora is based…
Why can't I scale my Aurora Postgres Serverless V2 down to zero?
I'm working with an RDS Aurora Postgres Serverless V2 instance, and I thought I could set the minimum capacity to zero to save on costs when it's not…
Can You Drop a Column in Aurora DSQL?
I've been experimenting with DSQL and tried using the standard SQL command to drop a column: `ALTER TABLE mytable DROP COLUMN mycolumn;`. However, I got an error saying…
How Can I Track Successful IAM Auth Connections to MySQL Aurora?
Hey everyone! We've recently set up IAM Authentication for our MySQL Aurora (Serverless v2) instance, but I'm hitting a wall trying to trace successful connection attempts. Currently, the…
Need Advice on AWS Data Warehouse Setup with On-Prem Databases
Hey everyone! I'm currently working on designing a data architecture and could really use some insights, especially from those who have experience with hybrid setups involving both on-premise…
How Can I Ensure No Write Downtime During Aurora MySQL Failovers?
I'm looking for ways to perform a managed planned failover in Aurora MySQL without any write downtime. I know the multi-master feature was deprecated, so I'm seeking suggestions…
What AWS Database Options Are Best for My Constant Data Insertion Needs?
Hey everyone, I currently run a PostgreSQL database on a dedicated server where I have 6 scripts constantly connected. These scripts scrape data from a video game API…
How to Manage Concurrent Requests and Database Connections Effectively?
I've been working on several serverless Node.js projects that make use of Aurora PostgreSQL with Sequelize as the ORM. We're running into issues with the number of concurrent…