📚
Databases
Postgresql Indexing Strategies
120
Cards
~60m
Study time
Advanced
Difficulty
Sample questions
- ▸What is an index in PostgreSQL?
- ▸What is a B-tree index in PostgreSQL?
- ▸Which index access method is the default in PostgreSQL?
- ▸What index types does PostgreSQL ship with for general use?
- ▸What is the main trade-off of any index?
📚
Databases
Postgresql Performance Tuning
103
Cards
~52m
Study time
Advanced
Difficulty
Sample questions
- ▸How do you find the slowest queries in Postgres?
- ▸How do you read an EXPLAIN plan?
- ▸Difference between EXPLAIN, EXPLAIN ANALYZE, EXPLAIN (BUFFERS, ANALYZE)?
- ▸Why is a Seq Scan faster than an Index Scan sometimes?
- ▸Function used to add a B-tree index for equality + range queries?
VS
🤔 Which should you study first?
Both topics are in the Databases category, so they complement each other well. We suggest starting with the smaller deck to build momentum:
Postgresql Indexing Strategies
120 cards · ~60 min · Advanced
Postgresql Performance Tuning
103 cards · ~52 min · Advanced
⭐ Quicker to complete