[dundee] "Scaling out" Postgresql puzzler...

[Robert Ladyman]

This article (you only need to read the first 4 paragraphs) makes for an 
interesting discussion:

http://petrohi.me/post/30848036722/scaling-out-postgres-partitioning

Basically, you can have a lot of users, each of whom can have more than one 
profile. 

There can be (2^63)-1 [about 9.22 x 10^18] profiles in the single profile 
table. Given that the population of the earth is about 7 billion (7 x 10^9), 
I calculate that that allows 1,317,624,576 profiles per person on Earth 
(about a billion profiles each)

The article goes on to talk about how they 'scale out' (that is, "horizontally 
scale") Postgresql by splitting the data up into (hashed) parts in case they 
suddenly go viral.

I know my opinion on this approach (surprise!). What's yours?

-- 

Robert Ladyman
File-Away Limited, 30 Church Street, Newtyle
Perthshire, PH12 8TZ SCOTLAND
Registered in Scotland, Company Number SC222086
Tel: +44 (0) 1828 898 158
Mobile: +44 (0) 7732 771 649
http://www.file-away.co.uk