Maximum size for database tables


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?

asked by anonymous 07.07.2016 / 20:17

1 answer


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.

07.07.2016 / 20:38