Vertica Test Results for Operating System Patches for Meltdown and Spectre Security Flaws

Sarah Lemaire, Manager, Vertica Documentation
January 11, 2018

For the latest Vertica update on the Meltdown and Spectre security flaws, read this blog: UPDATED: Vertica Test Results with Microcode Patches for the Meltdown and Spectre Security Flaws, published May 21, 2018. Vertica engineers have run performance tests using the operating system patches for the Meltdown and Spectre security flaws. Based on the results,...

Vertica Quick Tip: The LIMIT Analytic Function

Soniya Shah, Information Developer
January 11, 2018

This blog post was authored by Jim Knicely. Vertica contains an abundance of built-in SQL analytic functions. One of the lesser known but also one of the coolest is the LIMIT analytic function. Example Say I have the following table data: But I only want to see the latest test number for each date. For...