Thanks :) Yea indexes are where some of the real "magic" of database servers happens. It will be fun to write that up...
Yeah I'm excited to read about indexes in PostgreSQL. Indexes also add overhead to the database system as a whole, so they should be used sensibly — I'm looking forward to seeing your approach for good index candidates.