All Questions
3 questions
0
votes
1
answer
803
views
Postgresql Sequence Hopping
I have recently migrated (dump and restore) my database from AWS RDS PostgreSQL v12 to Aurora Serverless v2 PostgreSQL v14.6. The issue is we have setup sequencing in a table on old RDS, now in the ...
- 11
3
votes
2
answers
5k
views
How to restore a RDS Postgres instance from a snapshot exported to S3?
Amazon RDS Postgres database are backed up as snapshots automatically. Because of the high storage costs ($0.095 per GB-Month), I want to move them to S3 (Storage Class: Glacier Deep Archive: 0.00099 ...
1
vote
1
answer
2k
views
postgresql vacuum analyze on restored snapshot
Frequently we restore a Postgres DB from a RDS snapshot to an entirely new RDS instance. We notice that queries on certain tables perform really slowly but improve by a huge magnitude after running ...
- 143