OLTP and OLAP at a Glance drew the line between transactional (OLTP) and analytical (OLAP) work; this section measures it. demos/ch04/load/ loads BookNest's sample data into PostgreSQL 18 1,289 in its app-shaped form (books, customers, orders, order_items); PostgreSQL 18 on the WSL2 Host shows how.
MENU
OLTP vs OLAP
OLTP vs OLAP and the Analytical Workload