Examples 729–744 · Part VIII: Performance
| # | Example | Level |
|---|---|---|
| 729 | The index types PostgreSQL offers | Beginner |
| 730 | GIN for array containment | Intermediate |
| 731 | GIN operator classes for JSONB | Intermediate |
| 732 | GiST for range overlap | Intermediate |
| 733 | GiST for nearest-neighbour search | Intermediate |
| 734 | BRIN for naturally ordered data | Intermediate |
| 735 | Correlation decides whether BRIN works | Intermediate |
| 736 | Hash indexes | Intermediate |
| 737 | Trigram indexes for substring search | Intermediate |
| 738 | Full-text search indexes | Intermediate |
| 739 | Multicolumn GiST and GIN | Intermediate |
| 740 | Index size and maintenance cost by type | Intermediate |
| 741 | Covering indexes with INCLUDE on specialized types | Intermediate |
| 742 | Choosing between GIN and GiST | Intermediate |
| 743 | Index-only scans on specialized indexes | Intermediate |
| 744 | Choosing an index type | Advanced |
The solutions and explanations are in the book.