3 ms·
PostgreSQL 9.5 will have native sharding
- unmole 11y agoSo, it will be web scale?
- sickpig 11y agoI don't know about "web" scale, but it will definitely scale horizontally without using any external tools/extensions. There's still a somewhat annoying limitation that is related to the status of table partitioning in postgresql. In fact the planner automatically choose the right child table, be it on the same db or into another server, for UPDATE and SELECT statements but not for INSERTs. This is a known limitation and there's active work to fix it but don't hold your breath though.
- angrybits 11y agoYes, unlike 99% of the start-ups who demand it.
- spacemanmatt 11y agoNo, you will still need to plan your dynamic loading intelligently.