Partitioning Large Tables for Production Systems
Large database tables rarely fail because the database cannot store another row. They fail because indexes no longer fit efficiently in memory, maintenance operations take too long, queries scan irrelevant data, and routine deployments become operationally dangerous.
Oleksandr Andrushchenko
Aug 01