In depth analysis of database workloads and benchmarks

This page contains the central links to my various analysis of workloads and benchmarks.

TPC-H Analysis Series

• Q01 - Pricing Summary Report
• Q02 - Minimum Cost Supplier
• Q03 - Shipping Priority
• Q04 - Order Priority Checking
• Q05 - Local Supplier Volume
• Q06 - Forecasting Revenue Change
• Q17 - Small-Quantity-Order Revenue

Why are databases so hard to make?

Explaining databases in simple terms.

• Joins and Loops
• Group By and Aggregations
• Logging to Disk and Write Ahead Logging
• Row and Batch Based Execution
• CPU Usage in Databases
• Transaction logs and concurrency control
  • Tombstones and why PostgreSQL VACUUM is so stupid
  • High-Speed INSERT
  • Logging to Disk and WAL