Hacker News Reader

second yes to that - postgresql warm with plenty of RAM can do some fancy things and return an answer sub-millisecond too

cache is King

but large cache is expensive in the cloud and you cannot scale up/down without downtime

4TB of ram is only $71 per hour on AWS RDS. If you're at planetary scale that's not bad.