Good post! Looking forward to your next post about how indexes are handled.

pat_shaughnessy · on Oct 13, 2014

Thanks :) Yea indexes are where some of the real "magic" of database servers happens. It will be fun to write that up...

preillyme · on Oct 13, 2014

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.