Home
Starting Up
Case Studies DB
Products
Ideas DB
Vibe Coding Tools
Subscribe to IH+
Starting Up
Case Studies
Ideas DB
Products DB
Sign in
Join
13
Likes
10
Comments
Mastering Postgres indexes in 10 minutes
by
Fabien Herfray
https://fabien.herfray.org/posts/mastering-postgres-indexes-in-10-minutes/
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.