Skip to main content

Questions tagged [aws-aurora]

Managed cloud database service‎ from Amazon Web Services, available for Postgres or MySQL.

Filter by
Sorted by
Tagged with
6 votes
2 answers
3k views

AWS Aurora PostgreSQL Serverless: How do you pre-warm the shared buffer after scaling?

I'm using AWS Aurora PostgreSQL Serverless with autoscaling. It appears as though scaling clears the shared buffer, so right when we want to crank out the performance, we are forced to face-plant with ...
Brandon's user avatar
  • 163
3 votes
1 answer
7k views

Could not start WAL streaming, replication slot is active

I want to set up replication between two of my databases. One is an Aurora database in PG 10 the publisher, and the other one is an RDS database in PG 10. But I'm facing an issue, I have 500 GB of ...
yokoloko's user avatar
  • 171
3 votes
1 answer
2k views

Aurora PostgreSQL database using a slower query plan than a normal PostgreSQL for an identical query?

Following the migration of an application and its database from a classical PostgreSQL database to an Amazon Aurora RDS PostgreSQL database (both using 9.6 version), we have found that a specific ...
Sake's user avatar
  • 133
2 votes
0 answers
938 views

AWS Aurora queries much slower in "sending data" phase than RDS instance

I've been using an RDS instance during the development phase of a project. This was a db.t2.micro instance, so not very powerful at all. Today I have created a new Aurora (5.6) [serverless] database ...
Ian Bale's user avatar
2 votes
0 answers
911 views

RAISE NOTICE doesn't work as expected while using within Dynamic SQL block

I have a small piece of code to get all sequences and the current and maximum value of all sequences in a database. I have tried with recursive and some other alternatives through plain sqls, however ...
RBB's user avatar
  • 785
1 vote
2 answers
274 views

Extremely slow COUNT query on Aurora Postgress Serverless v2 with two tables

I'm designing a web application where sellers can offer their cars, banks provide various financing offers (e.g. 36 months, 25% downpayment, 25% final payment). Buyers come to this web app and they ...
bdadam's user avatar
  • 111
1 vote
1 answer
349 views

Time zone conversion in DMS from DB2 to Aurora Postgres

Challenge We are using AWS DMS to convert data from IBM DB2 into AWS Auroa Postgres IBM DB2 server is set to Eastern time (ET) zone. Timestamp related data inside DB2 is therefore in ET. Findings AWS ...
Padraic Renaghan's user avatar
0 votes
0 answers
161 views

Aurora Serverless - tables are empty after successful insert

I have MySQL 5.7.12 running on Aurora Serverless, and I've created a database with a table: mysql> show create database tpcc\G *************************** 1. row *************************** ...
j4nd3r53n's user avatar
  • 231