September 24, 2008

Vertica finally spells out its compression claims

Omer Trajman of Vertica put up a must-read blog post spelling out detailed compression numbers, based on actual field experience (which I’d guess is from a combination of production systems and POCs):

It’s clear what Omer means by most of those categories from reading the post, but I’m a little fuzzy on what “Consumer Data” or “Marketing Analytics” comprise in his taxonomy. Anyhow, Omer’s post is a huge improvement over my recent one — based on a conversation with Omer 🙂 — which featured some far less accurate or complete compression numbers.

Omer goes on to claim that trickle-feed data is harder for rival systems to compress than it is for Vertica, and generally to claim that Vertica’s compression is typically severalfold better than that of competitive row-based systems.


5 Responses to “Vertica finally spells out its compression claims”

  1. Database compression is heavily affected by the kind of data | DBMS2 -- DataBase Management System Services on September 24th, 2008 5:56 am

    […] whose details I forget for now — they could only do 2.5X. Edit: Vertica has now posted much more accurate versions of those numbers. Infobright’s 30X compression reference at TradeDoubler seems to be for a clickstream-type […]

  2. Oracle Database Machine performance and compression | DBMS2 -- DataBase Management System Services on September 28th, 2008 11:39 pm

    […] Each of the customers cited below received “half” an Oracle Database Machine. As I previously noted, an Oracle Database Machine holds either 14.0 or 46.2 terabytes of uncompressed data. This suggests the 220 TB customer listed below — LGR Telecommunications — got compression of a little under 10:1 for a CDR (Call Detail Record) database. By comparison, Vertica claims 8:1 compression on CDRs. […]

  3. Quick guide to Teradata’s announcements this week | DBMS2 -- DataBase Management System Services on October 14th, 2008 11:39 am

    […] work underway that’s getting 20X compression in call detail records, versus the 8X that Vertica claims. I’ll post more about that […]

  4. Oracle Exadata 2 capacity pricing | DBMS2 -- DataBase Management System Services on October 5th, 2009 10:11 am

    […] *Greg Rahn of Oracle tweeted me yesterday that one customer is getting 12-17X compression on “dimensional model” data. That sounds comparable to Vertica’s claim of 20X on “marketing analytics” and 30X on “consumer data&#8…. […]

  5. Oracle pushes compression for database scale-up | IT World Canada News on December 16th, 2013 9:26 pm

    […] the highest level in the database industry. Database analyst Curt Monash pointed out in an online post this week that analytic database start-up Vertica Inc. claims compression ratios from 5:1 to as […]

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.