Starburst Enterprise

Performance

Supercharge your queries, anywhere.

Take performance to the next level with Starburst.

Trino was built from the ground up to run SQL queries fast and at scale. It was built to solve the low performance, and lack of connectivity associated with using Hive. The creators of the Trino (formerly known as Presto SQL) project, needed to handle hundreds of users issuing tens of thousands of queries each day against petabytes of data. Trino was built for performance, on any data source, anywhere.

Starburst has made a series of enhancement to open source Trino to greatly improve query performance. First, Starburst provides improved and exclusive connectors which expose statistics allowing the query engine to generate faster and more optimal query plans. Starburst connectors also can pushdown the processing of queries, or parts of queries, into the connected data source to improve query performance. Dynamic filtering optimizations significantly reduces network traffic and load on data sources. And Starburst Cached Views include a suite of performance upgrades, with different options for accessing frequently used data.

Starburst Performance Whitepaper

Performance Whitepaper Cover

Starburst Performance Whitepaper

Read Whitepaper

Make better decisions faster than ever

Parquet reader

Trino has long served organizations with the ability to read Parquet files. And while already fast, Starburst delivers additional value with the Starburst Parquet reader which improves read performance on Parquet by an average of 20% over Trino.

Cost-based optimizer

Depending on the complexity of your SQL query there are many, often exponential, query plans that return the same result. However, the performance of each plan can vary drastically; taking only seconds to finish or days given the chosen plan. The cost-based optimizer creates the optimal path for each possible query plan. Starburst enables the cost-based optimizer to be leveraged across the majority of connectors.
View Documentation

Starburst Cached Views

Starburst Cached Views is a collection of performance features that provides customers with options on accessing frequently used data. Starburst customers benefit from materialized views, table scan redirections, and cache servcie/CLI for easy management, configuration, and most importantly, speed for accessing the same, or similar, data sets repeatedly. More efficiency, less work.

View Data Sheet

Pushdown

Sometimes it’s better to lean on other systems. Starburst can pushdown the processing of queries, or parts of queries, into the connected data sources resulting in better query performance, reduced network traffic and decreased load on the data source.
View Documentation

Dynamic filtering

Dynamic filtering optimizations significantly improves the performance of queries with selective joins by avoiding the read of data that would be filtered by join condition. It significantly boosts the performance of query federation.
View Documentation

Get started with Starburst

 

Install anywhere

Starburst includes everything you need to install and run Trino on a single machine, a cluster of machines, or even your laptop.

Download Free

Marketplace offerings

Try Starburst in your preferred marketplace

 

Starburst Enterprise

Fast, free, distributed SQL query engine for big data analytics

Starburst offers a free, unlicensed version which includes:

  • Certified and secure releases
  • Cost-based optimization for federated queries
  • Connector extensions, including table statistics
  • Usage metrics

Data leaders trust Trino (formerly PrestoSQL)

Netflix, Verizon, FINRA, AirBnB, Comcast, Yahoo, and Lyft are powering some of the biggest analytic projects in the world with Trino.

By signing up, you agree to communication about Starburst products and services. You may unsubscribe at any time. Your privacy is important to us, please review our privacy policy.

Free Download

No credit card required.