Table 4 Aggregated Q-error of cardinality estimates of scale workload by each model (lower is better)
From: Robust Cardinality: a novel approach for cardinality prediction in SQL queries
Technique | Mean | Median | Percentile | Maximum | ||
|---|---|---|---|---|---|---|
90 | 95 | 99 | ||||
PostgreSQL | 530.244 | 2.682 | 132.972 | 393.228 | 1641.207 | 223,040.000 |
MSCN | 31.005 | 3.211 | 41.068 | 96.326 | 601.186 | 2221.609 |
Robust Cardinality | 78.431 | 1.371 | 37.638 | 91.794 | 601.735 | 25,943.000 |