What can be the maximum size that a table can have? To be clearer: a table in MySQL, what is the maximum size it supports? And in SQL Server, Oracle, PostgreSQL?
Maximum size for database tables
5
asked by anonymous 07.07.2016 / 20:17
1 answer
10
Most boundaries are theoretical. In each version this can vary, although now it has become rare (perhaps it happens with the PostreSQL that is "low" near the others).
It is not always easy to determine, it depends on settings or combinations of factors. Some have no size limit for the table but for the database as a whole. Obviously if the table reaches that size there will be no room for a second table.
-
Microsoft SQL Server = > 524.272TB
-
MySQL MyISAM = > 256TB
-
MySQL InnoDb = > 64TB
-
Oracle = > 128 TB
-
PostgreSQL = > 1.6 TB
-
Firebird = > 18TB
-
SQLite = > no specific limit, operating system boundary
07.07.2016 / 20:38