PostgreSQL
GIN shown as a table-first walkthrough: tokenize document text, intersect posting lists, and fetch the matching document rows one step at a time.
PostgreSQL: GIN Deep Dive
Choose Tokenize, Search, or Insert Document to step through the GIN path and watch lexemes map to posting lists.
→ text -> lexemes -> posting lists -> candidate doc ids