3 ms·

You would be surprised at how far a well-tuned and optimized Postgres instance will get you. I've worked with so many teams who chase the newest and shiniest d

You would be surprised at how far a well-tuned and optimized Postgres instance will get you. I've worked with so many teams who chase the newest and shiniest database, deploying hundreds of nodes, and spending hundreds of man-hours staffing a sysadmin team to maintain it, only to eventually replace it with an old fashioned Postgres box. You just need an experienced DBA. Edit to add: many claims of "Postgres doesn't work at our scale" are frankly BS, and in large part due to an inexperienced ops team. Take a look at the top post on frontpage right now, for example: https://news.ycombinator.com/item?id=40372296 https://news.ycombinator.com/item?id=40372296

llm_trw 2y ago
> You would be surprised at how far a well-tuned and optimized Postgres instance will get you. I wouldn't be because I was hired after a team of very experienced DBAs saw their databases melt when trying to run analytics queries on the production database in 2012 for a telco. We then moved to HBase so analysts could figure out what parts of the network needed extra towers installed for peak demand with 15 second intervals. You can do this today because the database sits on a machine that is between 10 to 100 times as capable as what we had back then and the number of people using cellphones hasn't increased substantially. Again, don't look at this technology by what you can do today, but by what you could do back then.