In the talk we are going to optimize a real life Django application using advanced and exotic indexing techinics in PostgreSQL.
We are going to address performance issues in real life use cases using advanced indexing features in PostgreSQL:
- B-Tree indexes
- Covering indexes
- Partial indexes
- Function based indexes
- Hash indexes
- BRIN Indexes
If you are not sure what are all these index types are, this talk is for you!