Postgres Index types and where to find them

Tuesday 3:10 pm to 3:40 pm, in Salon F-H

About This Talk

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?

So today we will go over the 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!


    Photo of

    Louise Grandjonc