See More Under the Hood Posts
View All Vertica Blog Posts
Vertica on Kubernetes
Matt Spilchen, Senior Systems Software Engineer
January 26, 2023
This blog post has been updated from an earlier one to use new features that make deploying on your own system easier. Vertica released the VerticaDB operator in August, 2021, which began Vertica’s integration with Kubernetes. The operator automates many Vertica administrator tasks, such as restarting Vertica if any of the nodes go down, upgrading...
High Availability in an EON Mode Database with Read-Only Mode
Amrita Akshay, Information Developer
January 9, 2023
This blog is authored by Sruthi Anumula In Eon Mode, there are two major requirements for high availability: maintaining quorum and shard coverage. If either of them is lost, the whole cluster goes down. Before going into details, let us understand what quorum and shard coverage mean. Quorum: In Eon Mode, more than half of...
VerticaPy reaches a milestone at 100 stars
Mike Perrow, Senior Product Marketing Writer/Editor
December 14, 2022
The Vertica team is happy to share a milestone in our “VerticaPy journey”: We just reached 100 stars in our GitHub repo, and it’s growing every day. (Repo: That’s “repository” for those of you unfamiliar with GitHub.) Repos accumulate stars as an indication of user interest – think of them as bookmarks in a user’s...
Improving COUNT DISTINCT Performance with Approximate Functions
Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 16, 2022
A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...