Tips for optimizing PostgreSQL queries

Indexes and proper query planning go a long way.

Looking for tips to improve query performance in PostgreSQL for larger datasets.

Also check execution plans with EXPLAIN ANALYZE.