- Vacuum
- View
- Materialized View
- Recursive view
- Explain, Analyze
- Indexes
- B-tree
- Hash
- GiST
- GIN
- BRIN
- SP-GiST
- CTE
- Concurrency and lock
- Exclusive vs Shared lock
- Row level vs Table level lock
- Recursive CTE
- Stored Procedure
- Trigger
- Listen, Notify
- Partition
- Master-slave replication