3 ms·
Did I miss something, or does the article not mention anything about sharding in Postgres? Was that just not needed? Also, query planner maturity is a big deal
by frollogaston 1y ago
Did I miss something, or does the article not mention anything about sharding in Postgres? Was that just not needed?
Also, query planner maturity is a big deal. It's hard to get Spanner to use the indexes you want.
- monkeyelite 1y agoThere are probably fewer than 100 websites that couldn’t be a single Postgres instance on nice server hardware, with good caching.
- ScalaHanSolo 1y agoYeah, this is our read with Postgres here at Motion. I believe that Motion will easily be able to 10x on modern hardware along with various optimizations along the way.
- kevml 1y agoNot everything on the internet is a “website” and then there are several website hosting platforms that aggregate the individual concerns.
- monkeyelite 1y agoAll true points. I guess I just want to hear more about why they think sharding is important to them.
- maz1b 1y agoWhat makes you say that? AFAIK, the largest single dedicated servers you can buy on the market go up to around hundreds of cores and terabytes of ram, and NVME up to a PB~ish if you stack NVME/SSD/HDD as well. this is when i last checked.
- monkeyelite 1y agoYes. What do you have in mind?
- maz1b 1y agoYou mentioned how there's ~100 organizations that need more than one instance of postgres, wanted to know how you arrived at that opinion.