Postgres

Postgres is an open-source relational database.

It stores data in tables, supports SQL, enforces constraints, and provides transactional guarantees through ACID.

Core theory (general notes)

• Transactions, MVCC, Indexes, Query planner, Write-ahead log, Replication

PostgreSQL-specific topics

• Postgres transactions
• Postgres indexes
• Postgres query planner
• Postgres WAL
• Postgres replication
• Postgres VACUUM
• Postgres connection pooling
• Postgres JSON
• Postgres extensions