postgis/

spatial types, spatial predicates, and the indexes that make them fast. almost every postgis performance problem is a query that cannot reach the index.