News for hackers. Stuff that matters.
Re:Migrating to Postgres by mmiao on Wednesday May 14, 2025 @09:50PM (#43991075)
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
Re:Migrating to Postgres by jacobsenscott on Wednesday May 14, 2025 @11:14PM (#43991468)
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.
Re:Migrating to Postgres by mplanchard on Thursday May 15, 2025 @11:38AM (#43996168)
Depends on what you’re doing with them. We’ve currently got a postgres DB with >100b rows in some tables. Partitioning has been totally adequate so far, but we’re also always able to query with the partition keys as part of the filters, so it is easy for the query planner to do the right thing.