Careful Trading Complexity for 'Improvements'

Often I've come across technical proposals along the lines of:In 6 months we will outgrow our MySQL/Postgres instance. We will need to move our biggest table to a different horizontally scalable datastore. If we have a databas...