Azure Database for PostgreSQL - Flexible Server - Max Limit

Question

Azure Database for PostgreSQL - Flexible Server - Max Limit

Khuva, Parsottam 21

Hi Team,

Want to know about Azure Database for PostgreSQL - Flexible Server - Maximum number of database limit and also maximum number of tables support in single database limit.

Thank you for your support and help.

Accepted answer

3 additional answers

Your answer

Answer 1

Hi @Khuva, Parsottam , welcome to Microsoft Q&A forum.

As I understand you would like to know the limit of maximum number of databases and tables in Azure PostgreSQL - Flexible Server.

Practically there is no limit on number of databases or tables in databases that we can create in Azure PostgreSQL - Flexible Server. We can create as many as databases as we need till we don't exhaust the Compute and Storage options, please refer to below article on the same:

Compute and Storage options in Azure Database for PostgreSQL - Flexible Server

As an example, general purpose storage size varies from 32 GB to 16 TB. We can create any number of databases and subsequently tables in them as long as storage does not cross this limit. Once we reach this limit the server will start returning errors and prevent any further modifications. This may also cause problems with other operational activities, such as backups and WAL archival.

You can read through the above article as it mentions every detail.

Please let me know if this helps or else we can discuss further.

----------

If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!

Answer 2

Khuva, Parsottam 21

Thank you so much AnuragSharma-MSFT. This was very helpful.

Answer 3

Khuva, Parsottam 21

Hi AnuragSharma-MSFT,

One followed up question w.r.t. the same limit scenarios:
We have 1000+ devices and we have 10 tables to store data from each device. With regards to performance and maintainability point of view, which one of below is good for us:

Is it a good to have separate database for each device so 1000 databases and each database with 10 tables?
OR
Is it a good to have single database to store 1000 devices data i.e. Single database with 1000 device * 10 tables= 10000 tables.

Thank you for your support and help.

Anurag Sharma 17,631 Reputation points

2022-05-26T07:44:45.057+00:00
Hi @Khuva, Parsottam ,

Both the approaches come with pros and cons:

Single Database with Multiple tables:

Easy to Maintain as we just need to configure one database and all consuming applications will point to this single db.

Easier to maintain multiple objects like stored procedure, users and other database objects.

If we want to manual backup using dump and restore it is easier to do for one db

Backup file size will be huge as single db holds all data

Multiple Databases with less tables:

Easy to take manual backup of each database in case we want to create a replica of a particular db

Need to use multiple connection string for each database based on consuming application

Multiple copies of db objects need to be created

Backup size for database will be less as we have multiple database, so if one database we need to clone it is easier to do.

Performance wise we wont see much difference as postgreSQL tables can hold huge so it should definitely come down to maintainability and other parameters I mentioned above. One more factor to consider is if you want to have interaction between these tables then its better to go single database as cross-database query can be avoided.

Please let me know if this helps or else we can discuss further on this.
Khuva, Parsottam 21 Reputation points

2022-05-27T04:40:39.213+00:00

Thank you so much, this is very detailed information and useful to us.

Appreciate your help here.

Answer 4

Khuva, Parsottam 21

@AnuragSharma-MSFT, any inputs would be highly appreciated.

Share via

Azure Database for PostgreSQL - Flexible Server - Max Limit

3 additional answers

Your answer