PGCon2018 - 2.5
PGCon 2018
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Bruce Momjian |
| Schedule | |
|---|---|
| Day | Talks - Day 1: Thursday - 2018-05-31 |
| Room | DMS 1160 |
| Start time | 11:15 |
| Duration | 00:45 |
| Info | |
| ID | 1228 |
| Event type | Lecture |
| Track | Performance |
| Language used for presentation | English |
Flexible Indexing with Postgres
When considering database indexing, many people are confused by the many Postgres indexing structures available, and the many data-type-specific index lookup methods. For example, brin allows for efficient indexing of many columns. gin indexing specializes in the rapid lookup of keys with many duplicates — an area where traditional btree indexes perform poorly.
This is particularly useful for json and full text searching. GiST allows for efficient indexing of two-dimensional values and range types. This talk explores the various indexing features of Postgres and when to use them. This is ideal when presented after my Non-Relational Postgres presentation.