GIN Indexes

Nikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of.

Here are some links to things they mentioned:
• GIN Indexes postgresql.org/docs/current/gin.html
• Generalized Search Trees for Database Systems (Hellerstein, Naughton, Pfeffer) dsf.berkeley.edu/papers/vldb95-gist.pdf
• RUM extension pgxn.org/dist/rum/1.1.0
• Understanding Postgres GIN Indexes: The Good and the Bad (Lukas Fittl) pganalyze.com/blog/gin-index

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork