Mastering Postgres indexes in 10 minutes
Enough about the insides of Postgres indexes to impress your coworkers at the coffee machine or recruiters at a job interview. We'll look at B-Tree, Hash, GIN, GiST, BRIN indexes and focus on demystifying them.
fabien.herfray.org
As a fellow online teacher, I gotta say you did a great job with this one! It's concise, accurate and links to more in-depth resources. 👍
I agree. Well done!
I really appreciate it thank you so much 😊
I was thinking about doing something about Docker/Kubernetes next time. Maybe you'd have topic ideas?
Good quality post. As someone doing a bunch of Postgresql now where I think index posts are lacking is where, IMO, the common usage is: I want to go from a query that is slow to the indexes I need to make it faster. I've found out that I've added indices that actually don't impact the performance of the query so are just wasting space.
Thanks for the input, I think you're right. I'll try to write something focusing on usage in the future 👌
Was also thinking about doing a "index cheat sheet" as a table. With the different indexes, their main usecases and how to use them. More focused on how to use them then how they work.
Very detailed and easy to understand. Thanks!
Thank you :)
Nice explanations, also went down a rabbit whole of looking at partitions which are very interesting.
I never used partitions so far I think, should I? 😄
It's a relatively new feature isn't it, like Postgres 10?
Not too sure. But looks very useful for my use case.