Will Aurora PostgreSQL ever be anything but a dumpster fire?
Amazon Aurora Postgres: First Thoughts
Cost for an aurora cluster
RDS vs Aurora big price difference
Hello, PM for Amazon RDS and Aurora here.
We recommend Amazon Aurora Serverless for bursty workloads that spike up/down frequently. Think an e-commerce website which gets a lot of traffic on weekends and nothing on weekdays. Our customers love not having to scale the database to account for the surge or drop in traffic.
Amazon RDS and "regular" Amazon Aurora are for workloads that need sustained throughput. Think a search website which gets traffic throughout the day/week etc.
Hope that helps!
More on reddit.comVideos
-
Recent AWS ads in the console:
Amazon Aurora is a MySQL- and PostgreSQL-compatible enterprise-class database, starting at <$1/day.
After month-long support tag, I was told I "misinterpreted" the statement. The correct interpretation of that statement was that I could get a Aurora MySQL-compatible database for <$1/day, or an Aurora PostgreSQL-compatible database for no less than $7/day (or $2.50/day with 3yr upfront reservation).
2. The pricing section for Aurora PostgreSQL (https://aws.amazon.com/rds/aurora/pricing/) has "Serverless Pricing". Except...that Severless Pricing isn't available for Aurora PostgreSQL. This is the Aurora PostgreSQL-specific pricing section, and it's talking about pricing that simply isn't even available.
3. In the pattern of basically all Aurora docs/announcements, AWS recently announced "Amazon Aurora Backtrack โ Turn Back Time" (https://aws.amazon.com/blogs/aws/amazon-aurora-backtrack-turn-back-time/). Except if you the post all the way to the bottom, you find at the very end that is "Amazon Aurora MySQL Backtrack". I guess that title isn't as exciting?
4. AFAIK it's not documented anywhere, but major version upgrades for Aurora PostgreSQL are impossible. 100% impossible. Try creating from snapshots, setting up replicas, whatever....it is 100% not possible to do a non-minor upgrade of Aurora PostgreSQL ever. You have to kludge together your own text import/export process between clusters, migration scripts, etc. which takes literally days on any decent data set. I hope you like the version of PostgreSQL you start with, because that's the one you're keeping.
---
Anyone have the inside scoop? Is Aurora PostgreSQL actually used by anybody? Is it ever not going to be a misleading and poorly supported product? Or should I go back to non-hyped vanilla PostgreSQL RDS?