alt Hacker Newsa 100 million rows table is fairly small and you just don't need a distributed database. but you will need one if you hit 10 billion rows
a 100 million rows table is fairly small and you just don't need a distributed database. but you will need one if you hit 10 billion rows
You can partition that over 20 or 30 or more tables on one PG instance and have good performance - assuming a good partitioning key exists. If you need to query all 10B rows you'll have a bad day though.