Timeline for Sharding based on a range of ids?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 15, 2017 at 14:41 | comment | added | user1822 | @simo: hard to say. I would not make that dependent on the number of rows, rather then on the location of the data. If you e.g. have servers in Europe and US then I would shard the customers according to that. I don't think you need sharding for performance reasons if all nodes are local. Using many harddisks (RAID system) is usually more efficient - especially with the increasing abilities of Postgres to use multiple cores for a single query. | |
| Mar 15, 2017 at 11:54 | comment | added | simo | What is the number or rows at which shard becomes necessary? | |
| Mar 15, 2017 at 11:25 | vote | accept | simo | ||
| Mar 15, 2017 at 9:38 | history | edited | user1822 | CC BY-SA 3.0 |
deleted 460 characters in body
|
| Mar 15, 2017 at 9:22 | history | answered | user1822 | CC BY-SA 3.0 |