6
What can be the maximum size that a table can have? To make it clearer: a table in Mysql, what is the maximum size it supports? And in SQL Server, Oracle, Postgresql?
1 answer
10
Most boundaries are theoretical. In each version this may vary (the data below may be outdated), although it has now become rare (maybe it occurs with Postresql which is "low" near others).
It is not always easy to determine, depends on settings or combination of factors. Some have no size limit for the table but for the database as a whole. Obviously if the table reaches this size there will be no space for a second table.
Microsoft SQL Server => 524.272 TB
Mysql Myisam => 256 TB
Mysql Innodb => 64 TB
Oracle => 128 TB
Postgresql => 1.6 TB
Firebird => 18TB
Sqlite => no specific limit, operating system limit
-
um... interesting. I had researched this before, but I did not find the research results good, there were many differences, so I asked here because I trust the results and solutions posted here. Nor did I know that the capacity of the databases was so high (in my opinion).
-
I think it would be interesting to add the Firebird even if he didn’t ask >.<
-
2
@stringnome upon request...
Browser other questions tagged mysql sql database sql-server oracle
You are not signed in. Login or sign up in order to post.
This varies according to the manufacturer and the version. You would have to consult the documentation of each one. Some versions(life express) limit number of processors, base size or other features. Mysql
– rray