If you'd like to give Postgres a serious shot, I'd recommend taking a look at Citus: http://citusdata.com/ http://citusdata.com/. It's a distributed database fo

If you'd like to give Postgres a serious shot, I'd recommend taking a look at Citus: http://citusdata.com/ http://citusdata.com/. It's a distributed database forked from Postgres, and can easily handle billions of rows in realtime for certain use-cases. We use it at MixRank to store and run analytics on for ads we crawl in the internet (a respectable amount of data), and it handles extremely well. (Full disclosure: I know the Citus team well). I've also pushed Postgres to its limits and suspect you'd be able to make it work with that much data, though I wouldn't consider it a trivial exercise executing that transition on a production system. If you're seriously considering it though, feel free to reach out via the email in my profile.