OLTP
ELI5 — The Vibe Check
OLTP is the workhorse behind every app. It handles fast, small transactions: creating users, placing orders, updating profiles. Each operation touches a few rows and needs to be lightning fast. It's the cash register at the store, not the end-of-year financial report. Postgres and MySQL are classic OLTP databases.
Real Talk
Online Transaction Processing (OLTP) describes workloads characterized by high volumes of short, atomic transactions with low latency requirements. OLTP systems use row-oriented storage, B-Tree indexes, and ACID transactions optimized for point lookups and small range scans. They prioritize write performance, concurrency, and data integrity over analytical query throughput.
When You'll Hear This
"PostgreSQL is an OLTP database, not an analytics engine." / "Our OLTP database handles 10,000 transactions per second at peak."
Related Terms
B-Tree Index
A B-Tree index is the default index type that most databases create when you say CREATE INDEX.
MVCC
MVCC (Multi-Version Concurrency Control) is how databases let multiple users read and write at the same time without stepping on each other's toes.
OLAP
OLAP is all about analyzing huge amounts of data to answer business questions. 'What were total sales by region last quarter?' That's an OLAP query.
Read Committed
Read Committed is the default isolation level in PostgreSQL.