dgapitts/pgday-paris-btree-lsm-demo

Presentation setup and script demo for pgday Paris 2024

Readme / Overview for B-Tree (Heap) and LSM tree

General Setup Notes (Docker based)

• Build custom vidardb/postgresql:rocksdb-6.2.4 (lsm-tree)
• Setup jupyter notebooks via docker
• Cockroachdb setup 3 node cluster within docker (lsm-tree)
• CockroachDB docker compose file - 3 node cluster with pgbench (lsm-tree)
• Yugabytedb setup and simple big insert tests (lsm-tree)
• Exploring Yugabytedb - GUI Interface and Rule Based Optimizer (lsm-tree)≈
• Citus (columnar) docker setup

Tests - pgbench based couple with some exceptionally large and long transactions

• RocksDB Test - one VERY hot block
• RocksDB Test - interesting edge cases - drop column
• RocksDB Test - interesting edge cases - truncate table
• RocksDB Test - big table demo
• CockroachDB Test - Very big transaction - compaction spike
• Exploring-Yugabytedb.md
• Seaborn Exploring btree index efficiency

Presentation slides

• DB_Storage_B-tree_Columnar_LSM-tree_pgDay_Paris_2024.pdf