In Pursuit of PostgreSQL Performance by Ken Whitesell

Or: How someone who doesn’t really know what they’re doing manages to improve the performance of lengthy queries.