As developers we use indexes a lot, some by explicitly asking our ORM, some because of primary keys, unique constraint… But indexes go further than the default btree. And by the way, what is a btree? Louise is sharing a great talk about index types that postgreSQL has:
btree, gin, gist, sp-gist, brin, hash. What is the difference between them? What data type are they most fit for? How can they help with the performance of your application? How can you create a new index with a different type than the btree in python? All of these questions will be answered during this talk!