Conversation

What resources do you recommend for learning about

@PostgreSQL

indexes and theory behind #databases indexing in general?

Replying to

and

There are doc chapters with an implementation section for each of the index AMs: postgresql.org/docs/current/b, and postgresql.org/docs/current/g, for example

postgresql.org

70.4. Implementation

70.4. Implementation 70.4.1. GIN Fast Update Technique 70.4.2. Partial Match Algorithm Internally, a GIN index contains a B-tree index constructed over …

Replying to

and

Thanks. The docs require more background, so (for future reference) I also found helpful: 1. Abdul Bari YT video about btrees and b+ trees 2. Use-the-index-luke.com by @MarcusWinand 3. freecodecamp.org/news/database- about indexes by

@nath_kousik

use-the-index-luke.com

SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreS...

SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.

Replying to

and

Yeah, I was actually going to suggest the second one as well -- I know that it to be a good half-theory/half-practice kind of resource (though that distinction gets blurry)

4:19 AM · Oct 13, 2021Twitter Web App

Likes