Relational modeling, indexing strategies, PostgreSQL internals, transaction isolation, and query optimization.