Indexes Are Not Magic
A common misconception: add an index and queries get faster. Reality: wrong indexes slow writes and bloat storage. Use EXPLAIN ANALYZE to understand query plans before adding indexes.
Connection Pooling
PostgreSQL creates a process per connection. With hundreds of concurrent users, this crushes performance. PgBouncer or connection pooling in your ORM is non-negotiable at scale.