If you aren’t going to be using the FreedomPop Premier Service, or you’re done with the trial, you can easily cancel this service through your online account.
The June 2014 release of the VerticaKit has the following changes: Adds 1 queries Mergeout activity, mergeout durations, and mergeout volumes processed (submitted by Curtis) Added Projection Specific section & realigned queries
The May 2014 release has the following changes: Fixed schema for query_requests for query time distribution Adds 6 queries Nodes with less than recommended disk space available (40%) Workload analyzer tuning rules Tables without primary keys (help with optimizing joins)… Continue Reading
Vertica does not enforce uniqueness of primary key or unique constraints on load due to the potential overhead associated with the operation. There are ways to enforce uniqueness on load such as using MERGE, ANALYZE_CONSTRAINTS() or staging the data in… Continue Reading
I just learned about an undocumented function which allows you to tell the optimizer to ignore certain projections. Ignoring projections can be useful for testing or when optimizing queries. This post will show how to use the set_optimizer_directives() function to… Continue Reading
The April 2014 release has the following changes: Modified raw estimate data space utilization to only include super projections Removed suggestion to disable global profiling when not in use Added 6 queries Fault tolerance of system by returning K-safety level… Continue Reading
This post will focus on the benefits, restrictions and performance of partitioning projections. I’ll also explain my methodology for identifying tables for partitioning. A comprehensive guide on working with table partitions is available in the documentation.
My earlier post on the Overview of Join Operations discussed the join operations on a high level. This post will expand on the hash join.
There are two operator types, merge and hash; each which can be performed on the local node (a local join) or across two or more nodes (a network join). This post will discuss the two operator types and the differences… Continue Reading
The March 2014 release has the following changes: Added query labels to appropriate queries Moved profiling configuration into profiling section Updated documentation links to all use 6.1.x Added missing table aliases to columns for queries with joins Adds 8 queries