3 ms·
Hi, at Zalando, we are scaling all of our core businesses with PostgreSQL. Depending on your dataset, it can be fairly easy to shard your data for a horizontal
by sarnowski 11y ago
Hi, at Zalando, we are scaling all of our core businesses with PostgreSQL. Depending on your dataset, it can be fairly easy to shard your data for a horizontal scale-out (think of independent customer datasets). We have lots of databases that we scale horizontally to much bigger numbers. But, we also developed several tools that makes working with shards mostly transparent. Did not find a better source but one way we use PostgreSQL can be seen in detail in the following slides:
http://gotocon.com/berlin-2013/presentation/Why%20Zalando%20trusts%20in%20PostgreSQL http://gotocon.com/berlin-2013/presentation/Why%20Zalando%20...
- needusername 11y ago5 TB easily fits on a single Oracle instance on a single host.
- detaro 11y agoIt also easily fits in a Postgres instance on a single host, if you only look at "can store X amount of data". And even if Postgres is slower, for the money you save in license costs you can buy a few beefy nodes extra.
- brianwawok 11y agoYou can easily buy 10 postgres nodes for the license cost of 1 Oracle node.
- needusername 11y agoAnd your engineers work for free.
- mhd 11y agoFree, no. Less money than Oracle DBAs? (Yes.