[tomalaci]

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?

[ForHackernews]

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.