Hacker News Reader

How do these techiques work with replication and sharding? Or do you just use cloud managed pg like AWS RDS to not think about it?

Just don't keep all your old data in Postgres forever. Set up a nightly cron job to archive old crap out.

Now you'll never* don't need to shard your Postgres.

* Unless you work at a very rare company.