I've given a series of in-depth talks about database internals at Rzeszów Ruby User Group meetups:
- Why Doesn't the Database Use My Index? - how the indexes are built, and how to use them efficiently
- SELECT or There and Back Again - query processing details, from parsing down to storage and back to the client
- Full-text Search Inside Out - inverted index explained with simple implementation in Ruby as an illustration