7.4.3. Optimizing for Many Tables
Some techniques for keeping individual queries fast involve
splitting data across many tables. When the number of tables
runs into the thousands or even millions, the overhead of
dealing with all these tables becomes a new performance
consideration.