Amazon Aurora Supports PostgreSQL 14
infoq.com
infoq.com
https://cloud.google.com/blog/products/databases/introducing...
(I’m ceo of neon)
But for many other database such as "Amazon DocumentDB" , "Time Series" humour suggest it's Dynamo.
We use Aurora for all apps. It costs more, but needs little to no maintenance from our side
Yeah, for the most part it's better, but you lose the page cache buffer to stop you from running oom if you miscalculated your shared buffers, your cpu usage will go up significantly and sometimes things will be slower. While on paper the max IOPS are way higher, you do get more IOPS from migrating and then you run into other issues.
If you are or close to the 80k IOPS limit, or 65TB storage limit, there's no alternative, but the "aurora is always faster" line that AWS tries to sell you is bullshit.
The goal is to remain 100% Postgres compatible. So the network protocol, SQL queries, and tools, all can be used without any change. There are (were?) some (read: very few) caveats/restrictions, though, because of the heritage of, and need to be compatible with, Amazon RDS Postgres.
Disclosure: Member of the founding-team of Aurora Postgres; left the team quite a while back, so my knowledge is quite outdated.
Edit: There's a lot of literature, and public information (articles, conference talks, etc.) published by the Aurora team over the years, which all allude to these facts, and you can use that material to build your confidence that it is in fact Postgres compatible.
For no particularly good reason, I was under the impression Postgres Aurora was just a Postgres compatibility interface layer on top of a common substrate shared with the MySQL Aurora implementation.
During the same timeframe, many other companies have seen the same risk of AWS taking their open source products and providing competing managed offerings and have chosen various methods of protecting themselves from AWS competition. Many of them (including MongoDB, MariaDB, Confluent, CockroachDB, Sentry.io, Apollo, Graylog, Couchbase) have adopted licenses such as the SSPL, BSL, and even the Elastic license that prevent or strongly discourage AWS from using their products in a managed offering. Others such as Grafana Labs have partnered with AWS (under undisclosed terms) for a managed offering. It's an ongoing tension between companies that want to offer an open source product with a managed offering that monetizes it.
https://www.migops.com/blog/is-aurora-postgresql-really-fast...
[1] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...
Postgres 14 is supposed to have built-in connection pooling. If you're on it, do you still feel the need for RDS Proxy? We're using pgbouncer and can't decide if we should switch to RDS Proxy or upgrade to Postgres 14 and drop the external connection pooler.
Any references on this? I see a note somewhere about better connection handling, but nothing that would remove the need for connection pooling.
This is false. No PostgreSQL version has had a built-in connection pooler. There was a patch some years ago[0], but it didn't make it into PostgreSQL.
[0] https://www.postgresql.org/message-id/flat/ac873432-31cf-d5e...
Over the years cloud providers have added these features but they weren’t always available and definitely not something you would reach for in a cloud native setup.