How Twitch Uses PostgreSQL

blog.twitch.tv

Given Twitch is owned by Amazon, do they have the same cost considerations as the rest of us? Or do they get steeper discounts on EC2?

It makes sense to autoscale as hard as you like, if your cloud fees go back into your own pocket.

There was an interesting developer talk during the recent TwitchCon where they talked briefly about this.

Also remember that even Amazon has running costs, and I suspect as the autoscaling goes up, the profit margins drop.

An interesting article about how Twitch manages their Postgres cluster of around 100 machines.

Also their approach to use Aws autoscaling to scale read replicas is quite new and novel to me.

well I wonder how much man power they spend into their whole cluster. I mean look at how much setting tweaking / load balacing / auto scale / haproxy / pgbouncer / upgrade..

For the upgrade part I hope https://2ndquadrant.com/de/resources/pglogical/pglogical-doc... will get better and better.

Also the relative smorgasbord of DBMS that they use aside from postgres.

I definitely appreciate their transparency though it's hard to miss the "And we're hiring" plug at the end of it.

> it's hard to miss the "And we're hiring" plug at the end of it.

well I missed it. O.O

Reply on news.ycombinator.com