So why do all serious RDBMS systems have functionality for dynamically partitioning data based on the relevance of the data? Big databases are often set up to (for instance) have the last month's data on fast storage, and older data on slower/cheaper storage.

It also doesn't have the privacy concerns Google Sync has, because you can configure it to save to and load from any FTP host.