> and it's the one piece in the machinery that only scales vertically (i.e. with more powerful hardware)

PostgreSQL does scale horizontally ijs especially for a read-mostly app like social networking.