UPDATE: Vertica Test Results with Microcode Patches for the Meltdown and Spectre Security Flaws

Soniya Shah, Information Developer
May 21, 2018

This blog post was authored by Michael Leuchtenburg. Introduction Vertica engineers tested database performance with and without Meltdown and Spectre mitigations on both Haswell and Skylake microprocessors. As compared to no mitigation, with the fastest settings, we found a minimal, average 1% slowdown on Haswell, and an average 25% slowdown on Skylake. These results are...

Vertica Quick Tip: Getting Better Performance via External Table Row Counts

Soniya Shah, Information Developer
May 21, 2018

This blog post was authored by Jim Knicely. The Vertica optimizer uses its own internal logic to determine whether to join one table to another as an inner or outer input. When joining external tables, you can help out the optimizer immensely by letting it know the exact row counts of those external tables! For...