The other day I saw a tweet about blog posts it would be great to see, and one of them was “inside PostgreSQL: how a join works internally, what makes it fast”. Coincidentally, I’m taking a course on database system implementation, and I thought this would be a great way to study for my midterm! Of course, by the time I’ve finished this post, the midterm is long gone, but it was still a great incentive for me to start writing 🙂

Source: PostgreSQL Query Optimization · Jincheng Li