Vertica Blog

Vertica Blog

performance

Are Your Columns too Wide?

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 14, 2019

This tip expands on the earlier post on encoding and compression at Checking and Improving Column Compression and Encoding When you have millions to billions of rows, data type becomes a bit more important: even an extra 10 bytes per row across a huge data set will impact storage or performance (or both!). When I...
Create Read Update Delete in red 3D letters surrounded by 3D ones and zeroes

Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

James Knicely, Vertica Field Chief Technologist
October 17, 2019

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads (for example, through INSERT or COPY) Vertica recalculates aggregations with the new data and updates the...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

Paige Roberts, Vertica Open Source Relations Manager
October 16, 2019

The winds of change have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon...
Vertica text on blue background with purple jagged data line

Datadog Announces Integration with Vertica to Monitor Performance and Availability

Jeremiah Morrow, Senior Industry Product Marketing Manager
October 14, 2019

Datadog helps customers ensure high performance and availability of their applications by providing visibility into the full application stack: infrastructure, middleware, and applications. They have achieved this by building a robust set of turn-key integrations that include SaaS and Cloud solutions, automation tools, databases and server components, and many more. Now, they have announced integration...
Woman holding onto seat as high wind blows her hair and lots of data points past

Strong Winds of Change at Chief Data & Analytics Officers Event

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
August 14, 2019

Last week, Vertica sponsored the Chief Data & Analytics Officer event in Chicago. As a first-time sponsor, we were cautiously optimistic that we could meet with data and analytics leaders that were, according to event organizer IQPC, “…on the forefront of capitalizing on data and analytics in the enterprise as the volume, availability, and complexity...
Cyber security theme with abstract high speed technology POV motion blur

Vertica Test Results for MDS Security Patches

Gary Gray, Principal Information Developer
August 1, 2019

Several customers have asked us how Intel's recent MDS vulnerability patches will impact the performance of their Vertica databases. Vertica is known for its performance. So, anything that may impact its speed is a major concern for both us and our customers. Vertica engineers have finished a round of testing the OS and microcode fixes...
Cloud pattern in circuit board

Vertica Ranked #1 Cloud Data Warehouse

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
July 30, 2019

July has been quite an exciting month for Vertica. Our three keynote presenters are now confirmed for the Vertica Big Data Conference 2020 – Vertica founder and Turing Award winner Dr. Michael Stonebraker, kingpin of the famous MIT blackjack team Jeffrey Ma, and renowned analyst Ray Wang of Constellation Research. And, in addition to receiving...
hands in surgical gloves hold vial with small amount of blood

Is Data Warehouse as a Service Out for Your Blood?

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
July 3, 2019

Last weekend, I finally had the chance to watch the popular, yet alarming HBO documentary – The Inventor: Out for Blood in Silicon Valley. If you haven’t seen it, it’s a true story that centers on Elizabeth Holmes, ex-Theranos CEO, who dropped out of Stanford to build a company that promised to revolutionize blood testing...

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...

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

Rebalance a Large Partitioned Table

Sarah Lemaire, Manager, Vertica Documentation
March 23, 2016

Your organization is collecting data as fast as your Vertica cluster can store it, so fast that you need to add a few nodes to your cluster. After you add those nodes, Vertica must distribute the data across all the existing and new nodes for best performance. We call this operation rebalancing.