Re:PostgreSQL 9.5 will have native sharding
by unmole on Thursday April 09, 2015 @04:59AM
(#9346411)
So, it will be web scale?
[ Parent
| on HN ]
Re:PostgreSQL 9.5 will have native sharding
by sickpig on Thursday April 09, 2015 @05:05AM
(#9346426)
I 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.
Re:PostgreSQL 9.5 will have native sharding
by angrybits on Thursday April 09, 2015 @10:06AM
(#9347568)
Yes, unlike 99% of the start-ups who demand it.
Re:PostgreSQL 9.5 will have native sharding
by spacemanmatt on Thursday April 09, 2015 @04:10PM
(#9350671)
No, you will still need to plan your dynamic loading intelligently.