▶ Databases Labs

Databases Labs

B-tree, MVCC, replication lag, connection pool, pgvector ANN.

5Interactive labs
100%Single-file HTML
Interactive labs

All 5 labs in this category

Advertisement
LAB · 01

B-tree Index Visualizer

Insert values; see B-tree splits and growth.

Open lab
LAB · 02

Database Connection Pool Sizing

Too few: queueing. Too many: thrashing. Find the sweet spot.

Open lab
LAB · 03

MVCC Snapshot Isolation

Two transactions, three versions, snapshot isolation.

Open lab
LAB · 04

pgvector ANN Search

2D vector search with adjustable recall threshold.

Open lab
LAB · 05

Postgres Streaming Replication Lag

Adjust write rate vs replica apply rate; see lag accumulate.

Open lab