The Stack Overflow podcast is a weekly conversation about working in software development, learning to code, and the art and culture of computer programming. Hosted by Paul Ford and Ben Popper, the series features questions from our community, interviews with fascinating guests, and hot takes on what’s happening in tech. Founded in 2008, Stack Overflow is empowering the world to develop technology through collective knowledge. It’s best known for being the largest, most trusted online community for developers and technologists. More than 100 million people come to Stack Overflow every month to ask questions, help solve coding problems, and develop new skills.
How to write high-performance SQL for your Postgres database
pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs. You can also find them on YouTube, where Lukas posts a weekly show called 5mins of Postgres.
Lukas was a founding engineer of Citus Data. Citus is an open-source extension to PostgreSQL that was eventually acquired by Microsoft. Find them on GitHub.
If you’re new to the topic, SQL (Structured Query Language) is a language for querying databases, introduced in the 1970s.