DBScholar

Back to papers

Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet

Summary: Telemetry from 400 Amazon Redshift instances shows cloud data-warehouse workloads diverge from TPC-H/DS: prominent write-heavy pipelines, temporal variability in load and query types, repetitive queries, and heavy-tailed distributions of query/workload properties. Argues benchmarks must broaden beyond pure query-engine throughput to model ingestion, temporal dynamics, repetition and tail behavior, and releases a 3-month query-statistics dataset to seed more realistic benchmark design. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h9f843dcbec00aa86
Venue
VLDB
Year
2024
Pagerank
9.6212919e-05
Overall Rank
1,791 | 88.00%
DOI
10.14778/3681954.3682031
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{renen_vldb24,
        title = {{Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet}},
        author = {van Renen, Alexander and Horn, Dominik and Pfeil, Pascal and Vaidya, Kapil and Dong, Wenjian and Narayanaswamy, Murali and Liu, Zhengchun and Saxena, Gaurav and Kipf, Andreas and Kraska, Tim},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {11},
        pages = {3694--3706},
        doi = {10.14778/3681954.3682031},
        url = {https://doi.org/10.14778/3681954.3682031},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 38 of 38 citing papers.

Rank Citing Paper Year Venue Pagerank
3,909 SQLStorm: Taking Database Benchmarking into the LLM Era 2025 VLDB 6.9127576e-05
4,641 How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks 2025 SIGMOD 6.4739208e-05
5,521 Runtime-Extensible Parsers 2025 CIDR 6.0819893e-05
6,658 Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like? 2025 VLDB 5.7025639e-05
7,388 Towards Foundation Database Models 2025 CIDR 5.5211011e-05
7,561 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4784915e-05
7,827 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4297836e-05
7,844 Bespoke OLAP: Synthesizing Workload-Specific One-size-fits-one Database Engines 2026 VLDB 5.4255843e-05
8,061 Demonstrating SQLBarber: Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2025 SIGMOD 5.3820955e-05
8,662 PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking 2025 VLDB 5.2781431e-05
9,011 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB 5.2238303e-05
9,243 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 5.1864799e-05
9,494 SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2026 SIGMOD 5.1541298e-05
9,585 B-Trees Are Back: Engineering Fast and Pageable Node Layouts 2025 SIGMOD 5.1406489e-05
9,662 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1283524e-05
9,719 The HANA Native Query Engine for Lakehouse Systems 2025 VLDB 5.1229327e-05
9,995 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.0845476e-05
10,119 LiquidCache: Efficient Pushdown Caching for Cloud-Native Data Analytics 2025 VLDB 5.0638787e-05
10,166 End-to-End Declarative Data Analytics: Co-designing Engines, Interfaces, and Cloud Infrastructure 2026 CIDR 5.0559291e-05
10,262 Active Data Lakes: Regaining Physical Data Independence Without Losing Interoperability 2026 VLDB 5.0380426e-05
10,278 Redbench: Workload Synthesis From Cloud Traces 2026 VLDB 5.0334833e-05
10,323 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 5.0241309e-05
10,387 CacheServer: Disaggregated Caching for Cloud Databases 2027 SIGMOD 4.9605343e-05
10,429 Survivorship Bias in Industrial Database Workloads 2026 CIDR 4.9605343e-05
10,545 HotHash: Hotness-Aware Consistent Hashing for Cloud Databases 2026 SIGMOD 4.9605343e-05
10,561 NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,764 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9605343e-05
10,822 Toward Drift-Aware Database Benchmarking 2026 VLDB 4.9605343e-05
10,894 Revisiting Filtered ANN Benchmarks: A Hardness-Controlled Benchmark Generator for Realistic Evaluation 2026 VLDB 4.9605343e-05
10,951 One Pass to Parse Them All: Fused Parallel CSV Processing 2026 VLDB 4.9605343e-05
10,956 Accelerating String-Heavy Queries with LLM Token Tables 2026 VLDB 4.9605343e-05
10,979 Incremental Query Optimizer Statistics in Amazon Redshift 2026 VLDB 4.9605343e-05
10,984 FastCompose: Eliminating Compilation Cold Starts in Query Execution with Composition 2026 VLDB 4.9605343e-05
11,011 Ultron: History-Based Query Optimization at Databricks 2026 VLDB 4.9605343e-05
11,043 Demonstrating GenDB: Instance-Optimized and Customized Query Processing Code Generation via LLM Agents 2026 VLDB 4.9605343e-05
11,196 Flux: Unifying Heterogeneous Infrastructure for Alibaba AnalyticDB 2025 SIGMOD 4.9605343e-05
11,488 Sampling-based Predictive Database Buffer Management 2025 VLDB 4.9605343e-05
11,490 Mayura: Exploiting Similarities in Motifs for Temporal Co-Mining 2025 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Previous Page 1 / 1 Next

Semantically Similar Papers