Changes to connection handling with Aurora Postgres?
Were any changes made to how connections are handled between PostgreSQL and Aurora Postgres? Specifically, there are limitations in Postgres with connections due to memory usage, and a customer wants to know if any improvements were made with Aurora.
In addition, if the connection "math" is the same as vanilla Postgres, is the total max connections for a cluster equal to the # of replicas * max connections per, or something else?
Thanks for any insights!
This documentation page shows the difference between Aurora PostgreSQL and plain vainilla PostgreSQL on RDS: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.Compare.html
Likewise, these are the features that are supported in PostgreSQL on RDS: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions
Relevant questions
Changes to connection handling with Aurora Postgres?
Accepted Answerasked 3 years agoXA Global Transaction Support for Aurora Postgres
asked 3 months agoPostGIS and Aurora compatibility: experience feedback
Accepted AnswerNo Options to migrate from RDS Postgres to Aurora
asked a month agoInvoke lamda async from Aurora PostgreSQL
Accepted Answerasked 2 years agoHow to create SSL dblink connection from RDS to postgres on premise?
asked 4 months agoAurora PostgreSQL - recommended maximum number of databases (for a multi-tenant data layer)
Accepted Answerasked 3 years ago60K updates to RDS Postgres - performance challenge
Accepted Answerasked 2 years agoMigration from Aurora PostgreSQL back to regular RDS
Accepted Answerasked 3 years agoUse RDS Postgres Replicas as a cluster
Accepted Answerasked 4 months ago