PDXPUG April 2023: Know Your Index Part 2

Location:
PDX Code Guild
407 NE 12th Avenue, Portland, OR 97232
The parking lot is behind the building on Flanders.

Speaker: Grant Holly

We are going to continue our tour of indexes in Postgres. This time around we are going to look into the index data structures, and how they affect performance. We will cover B+Trees, hash tables, and inverted indexes as well as looking at the Brin and SP-Gist indexes.

Later we will talk about use cases for the different kinds of indices. And finally, we will settle the “indexes” vs “indices”!

This talk is for all experience levels. Bring your questions and stories. We are looking forward to seeing you there.