Vertica Blog

Vertica Blog

query

Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

Paige Roberts, Vertica Open Source Relations Manager
May 10, 2019

This week, some very cool things have gone into the newest version of the Vertica Analytics Platform that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do...

Use MERGE to Update 1 Million Rows in 2 Seconds

Moshe Goldberg, Vertica System Engineer
May 22, 2017

This blog post was co-authored by Yassine Faihe, Michael Flower, and Moshe Goldberg. Updating One Million Records in Two Seconds To illustrate the true power of MERGE, this article describes how we used MERGE to demonstrate Vertica's performance at scale. SQL MERGE statements combine INSERT and UPDATE operations. They are a great way to update...

The Life of a Query, According to Henry Ford

Vertica Technical Team
January 10, 2017

Modern Database Analytics

Redesigning Projections for Query Optimization

Vertica Technical Team
November 9, 2016

When you submit a query to Vertica, the Vertica query optimizer automatically assembles a query plan, which consists of a set of operations to compute the requested result. Depending on the properties of the projections defined in your database, the query optimizer can choose faster and more efficient operations. Thus, it?s important to recognize what...

Troubleshooting Vertica Query Performance with System Tables

Sarah Lemaire, Manager, Vertica Documentation
August 29, 2016

Do you want to learn how to troubleshoot your query performance issues?  We've got you covered. Just attend
Database Server Room

Do You Need to Put Your Query on a Budget?

Sarah Lemaire, Manager, Vertica Documentation
July 6, 2016

Before we scare you away with the word "budget", rest assured that after reading this blog, you won?t have to give up your favorite activities or sell your car. What you will be able to do is understand how Vertica resource pool parameters affect query budget.
Three 3D arrows, different colors pointing in different directions

Looking Under the Hood at Vertica Queries

Sarah Lemaire, Manager, Vertica Documentation
March 2, 2016

When you submit a query to Vertica, you want it to execute as quickly and efficiently as possible. The query optimizer creates a plan that is designed to do just that. The directives in the query plan determine your query's run-time performance and resource consumption, but the properties of your projections and the system parameters also impact...

Tell the Optimizer You Have a Better Plan

Michael Kronenberg
December 17, 2015

You're upgrading your database and some query appears to execute less efficiently than before. What can you do? Vertica addresses this concern in Vertica 7.2 with directed queries

Using JDBC Routable Query API for High Concurrency and High Throughput

Shubhangi Vajpayee
September 14, 2015

Does your organization use high-volume short requests that return a small number of results on a single node? Do you deal with low latency and high concurrency queries, and want to achieve high throughput? You could benefit by using the Vertica JDBC Routable Query API that uses fewer system resources than distributed queries.