This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 16%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Azure community,
Why is there a size limitations for PostgreSQL database? When I tried to create a flexible PostgreSQL instance, I could allocate max 32TB of size. As far as limitations from PostgreSQL is concerned, 32TB is limit for a single table not for whole database, then why has Azure placed such limitation?
Do azure has any alternative database technology/solution where a single node can have more than 32TB size? we are looking towards 100TB per node. I understand there is Hyperscale, but that still would have a single node max limitation.
we are currently using Snowflake, but our case is uniq where we simply has too much data to retain but we do not need to do any data science on that, simple CR(no U/Update) operations on recent data while old data ( D/Delete) needed to retain for some period.
Thank you.
If I understand correctly you are asking about the size limitations for PostgreSQL databases in Azure and if there are any alternative database technologies/solutions that can handle larger sizes. an you are currently using Snowflake.
This limit is set by Azure and is not related to any limitations in PostgreSQL itself. The reason for this limit is to ensure that the service can provide high performance.
Azure Hyperscale for PostgreSQL is an alternative solution that can handle larger sizes,Azure Cosmos DB for PostgreSQL is another alternative solution that can handle larger sizes and provides a globally distributed, multi-model database service.
I will also check with the internal product team and provide more details.
Regards
Geetha
@PATEL, HEMANSHU we are considering onboarding premium managed disk v2’ in comming months V2 supports 64 TB..
does that work for you?
Regards
Geetha
Its better than 32TB, but as I mentioned our 1 day worth data is approximate 11TB and we will need to retain for a year. So even in Hyperscale we would need more than 50 nodes, in that condition I'm not sure if cost wise, we will be better than using Snowflake or not.