Vertica Blog

Vertica Blog

Best Practices

Best Practices for Refreshing Large Projections

Sarah Lemaire, Manager, Vertica Documentation
May 27, 2015

More than once I have worked with customers who need to update a superprojection or create a new projection for a large fact table. It seems like a simple and easy process: just create a projection and perform a refresh. However, refreshing projections for large fact tables can produce unwanted complications. In this blog, we?ll...

Optimizing for Merge Join

NorbertK
October 22, 2014

In an earlier post,

Workload Management Metrics ? A Golden Triangle

Po Hong
July 17, 2014

Modern databases are often required to process many different kinds of workloads, ranging from short/tactical queries, to medium complexity ad-hoc queries, to long-running batch ETL jobs to extremely complex data mining jobs (See my previous blog on workload classification for more information.) DBAs must ensure that all concurrent workload, along with their respective Service Level...
Programmer

Optimizing Big Data Storage in Vertica

ramakrishna
April 29, 2014

With the explosion of data volumes all enterprises are capturing, new technological solutions, such as Vertica, offer a solution to non-expert users who need to analyze and monetize their Big Data. If you are a non-expert user, the Database Designer (DBD) module in Vertica can help you choose a physical database design that minimizes storage...