PostgreSQL 9.5 will have native sharding

#1

Post by sickpig » Thu, Apr 09, 2015, 7:31 AM UTC

PostgreSQL 9.5 will have native sharding
depesz.com

Re: PostgreSQL 9.5 will have native sharding

#2

Post by unmole » Thu, Apr 09, 2015, 8:59 AM UTC

So, it will be web scale?

Re: PostgreSQL 9.5 will have native sharding

#3

Post by sickpig » Thu, Apr 09, 2015, 9:05 AM UTC

unmole wrote: post #2

So, it will be web scale?

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

#4

Post by angrybits » Thu, Apr 09, 2015, 2:06 PM UTC

unmole wrote: post #2

So, it will be web scale?

Yes, unlike 99% of the start-ups who demand it.

Re: PostgreSQL 9.5 will have native sharding

#5

Post by spacemanmatt » Thu, Apr 09, 2015, 8:10 PM UTC

unmole wrote: post #2

So, it will be web scale?

No, you will still need to plan your dynamic loading intelligently.