Aurora Postgres Limitations - Is there any?

0

Hi all, I'd like to be sure that AWS Aurora does not have any hard limits other than the ones listed on the Quotas and constraints docs page, could anyone confirm that? We'd like to use Aurora with Postgres and it is crucial to know whether or not Aurora has any limits on creating DB schemas. So far I've found none, but I'm no expert in this matter. AFAIK Postgres itself has no hard limits on the amount of schemas. Any help is appreciated!

  • The link you reference is AWS-specific for our Aurora PostgreSQL (APG) managed service. Since APG is built from open source PostgreSQL, it inherits all the hard limitations of PostgreSQL. These are listed for each specific major version in the community documentation which can be found at https://www.postgresql.org/docs/current/limits.html.

    Please note that the time it takes to perform a major version upgrade in PostgreSQL is dependent on the number of objects in your system (i.e., # of databases, schemas, tables, indices, etc.) so please factor that into your database design decisions!

  • @PThawley thank you for your insights!

asked 4 months ago429 views
1 Answer
1
Accepted Answer

Thanks for contacting AWS.

I understand that you would like to know if there is any Hard limit on the number of schemas that can be created in Aurora Postgres instance.

I have researched on the query and could confirm that there is no hard limit set for the number of schemas that can be created in Aurora Postgres . Your understanding is correct in terms of Postgres limits as no such hard limit is imposed.

Only hard/Soft limits for Aurora are these : [+] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_Limits.html : Quotas and constraints for Amazon Aurora

However, The higher the number of schemas you create , Higher the resources consumed. As long as you have sufficient storage ( In case of Aurora, storage is auto scaled so this not an issue ) and Right instance class there should not be any issues with 'n' Schema creations.

I Hope this helps !

AWS
answered 4 months ago
profile picture
EXPERT
reviewed 2 months ago
  • Thank you for your help!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions