Data types

Indices

Secondary Keys

Indexing JSONs

Indexing wildcard searches and texts + Full-text indices

Invisible indices

Duplicate indices

PostgreSQL pitfalls

Denormalisation