Live-DB revalidation — v1.0.0
The 3-DB × 3-variant release matrix plus the first at-scale measurement of the 0.9.x graph/text families.
Headline. Every cell of the 3-DB × 3-variant matrix
materializes on v1.0.0 with no regression vs the v0.8.0 numbers
(every delta within the ±20% gate), and — for the first time — the 0.9.x
families are measured at realistic scale: the native
graph_relationships pass, the centrality snapshot costs
(the measured case for cheap-by-default), and a text bridge end to end.
Feature counts: narrow and all-agg reproduce v0.8.0 exactly; wide matches
exactly on dirtyduck/chicago311 and emits ~6% more columns on donorschoose
(0.9.x planner evolution; the config is identical).1 · The regression matrix
| database | variant | features | shards | rows | seconds | was (v0.8.0) | Δ | dup-names | status |
|---|---|---|---|---|---|---|---|---|---|
| dirtyduck | narrow | 147 | 1 | 22,169 | 2.5 | 3.0 | -17% | 0 | materialized |
| dirtyduck | all-agg | 272 | 1 | 22,169 | 7.0 | 7.5 | -7% | 0 | materialized |
| dirtyduck | wide | 1,252 | 1 | 22,169 | 60.2 | 63.2 | -5% | 0 | materialized |
| chicago311 | narrow | 28 | 1 | 30,654 | 0.8 | 0.8 | +0% | 0 | materialized |
| chicago311 | all-agg | 191 | 1 | 30,654 | 5.7 | 6.0 | -5% | 0 | materialized |
| chicago311 | wide | 907 | 1 | 30,654 | 47.5 | 49.2 | -3% | 0 | materialized |
| donorschoose | narrow | 175 | 1 | 3,000 | 0.5 | 0.4 | +25% | 0 | materialized |
| donorschoose | all-agg | 1,063 | 1 | 3,000 | 8.3 | 7.6 | +9% | 0 | materialized |
| donorschoose | wide | 39,022 | 33 | 3,000 | 501.1 | 470.1 | +7% | 0 | materialized |
2 · New: the 0.9.x families at scale
| workload | database | shape | wall-clock | value check |
|---|---|---|---|---|
| graph_relationships (native SQL pass) | dirtyduck | 13,950 chain edges · full cohort × 3 as-of dates = 66,507 rows · DEGREE + windowed variants | 7.8s | hand-SQL ×5 ✓ |
| graph_relationships (native SQL pass) | donorschoose | 608 school edges · 9,000 rows | 1.6s | hand-SQL ×5 ✓ |
| CentralityBridge.materialize_snapshots | dirtyduck | 13,950 edges × 3 windows (17,011 snapshot rows) | cheap 0.5s · heavy 17.2s (34.4×) | — |
| CentralityBridge.materialize_snapshots | donorschoose | 608 edges × 3 windows | cheap 0.3s · heavy 0.1s (0.3×) | — |
| SentimentBridge → spine (end to end) | dirtyduck | 50,000 of 261,088 inspector comments (cap 50,000, recorded) → MEAN/MIN/MAX/COUNT × windows | bridge 0.9s · spine 1.1s | hand-SQL ×3 ✓ |