September 25, 2018
The video of my presentation below walks you through ‘Indexing in PostgreSQL’ – a key component to database performance.
http://www.youtube.com/watch?v=VVG8nYqIiMI
This presentation covers the following topics:
- Various ways to access data in PostgreSQL
- Different types of indexes supported by PostgreSQL
- Internals of BTree and BRIN indexes
- Overview of GIN and GiST indexes
- How to find missing indexes
- How to find unused indexes