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.5304799e-05
Overall Rank
1,839 | 87.64%
DOI
10.14778/3681954.3682031

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 37 of 37 citing papers.

Rank Citing Paper Year Venue Pagerank
4,132 SQLStorm: Taking Database Benchmarking into the LLM Era 2025 VLDB 6.7885553e-05
5,511 Runtime-Extensible Parsers 2025 CIDR 6.0994747e-05
5,683 How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks 2025 SIGMOD 6.0392183e-05
6,648 Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like? 2025 VLDB 5.7215989e-05
7,385 Towards Foundation Database Models 2025 CIDR 5.5385053e-05
7,817 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4477841e-05
7,822 Bespoke OLAP: Synthesizing Workload-Specific One-size-fits-one Database Engines 2026 VLDB 5.4461624e-05
8,036 Demonstrating SQLBarber: Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2025 SIGMOD 5.4025086e-05
8,332 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.3528188e-05
8,636 PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking 2025 VLDB 5.2981619e-05
9,454 SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2026 SIGMOD 5.1736782e-05
9,670 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1452097e-05
9,684 The HANA Native Query Engine for Lakehouse Systems 2025 VLDB 5.1423628e-05
9,956 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.1038322e-05
9,998 B-Trees Are Back: Engineering Fast and Pageable Node Layouts 2025 SIGMOD 5.0979044e-05
10,080 LiquidCache: Efficient Pushdown Caching for Cloud-Native Data Analytics 2025 VLDB 5.0830849e-05
10,125 End-to-End Declarative Data Analytics: Co-designing Engines, Interfaces, and Cloud Infrastructure 2026 CIDR 5.0751052e-05
10,148 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB 5.0715586e-05
10,226 Active Data Lakes: Regaining Physical Data Independence Without Losing Interoperability 2026 VLDB 5.0571508e-05
10,242 Redbench: Workload Synthesis From Cloud Traces 2026 VLDB 5.0525742e-05
10,290 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.0431863e-05
10,350 Survivorship Bias in Industrial Database Workloads 2026 CIDR 4.9793485e-05
10,468 HotHash: Hotness-Aware Consistent Hashing for Cloud Databases 2026 SIGMOD 4.9793485e-05
10,484 NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis] 2026 SIGMOD 4.9793485e-05
10,693 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9793485e-05
10,751 Toward Drift-Aware Database Benchmarking 2026 VLDB 4.9793485e-05
10,823 Revisiting Filtered ANN Benchmarks: A Hardness-Controlled Benchmark Generator for Realistic Evaluation 2026 VLDB 4.9793485e-05
10,881 One Pass to Parse Them All: Fused Parallel CSV Processing 2026 VLDB 4.9793485e-05
10,886 Accelerating String-Heavy Queries with LLM Token Tables 2026 VLDB 4.9793485e-05
10,909 Incremental Query Optimizer Statistics in Amazon Redshift 2026 VLDB 4.9793485e-05
10,914 FastCompose: Eliminating Compilation Cold Starts in Query Execution with Composition 2026 VLDB 4.9793485e-05
10,941 Ultron: History-Based Query Optimization at Databricks 2026 VLDB 4.9793485e-05
10,973 Demonstrating GenDB: Instance-Optimized and Customized Query Processing Code Generation via LLM Agents 2026 VLDB 4.9793485e-05
11,127 Flux: Unifying Heterogeneous Infrastructure for Alibaba AnalyticDB 2025 SIGMOD 4.9793485e-05
11,429 Sampling-based Predictive Database Buffer Management 2025 VLDB 4.9793485e-05
11,431 Mayura: Exploiting Similarities in Motifs for Temporal Co-Mining 2025 VLDB 4.9793485e-05
11,433 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 4.9793485e-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