Know the Postgres index types such as multicolumn indexes and partial indexes,
don’t over-index,
use more joins,
prefer INNER JOINs,
understand the EXPLAIN output,
and don’t try to optimize on your development machine.