Inspired by https://news.ycombinator.com/item?id=31309729.
Managing databases has always been one of the most fun things for me, optimising queries, finding inefficiencies, figuring out how to squeeze more performance out of the DB servers.
But most of it has come from just trying whatever I can think of, and I'm sure I'm missing some fundamentals or more advanced techniques, so I figured I'd ask y'all, and see what we can come up with.