The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Are queries against default super projections distributed?
The documentation seems to indicate that those queries can still be distributed: "ALL NODES—Automatically replicates the unsegmented projection on each node. To perform distributed query execution, Vertica requires an unsegmented copy of each small table superprojection on each node." However, we've noticed that when the query planner uses a default super projection (UNSEGMENTED ALL NODES) for a query, the I/O and CPU load doesn't appear to get distributed across multiple nodes in the cluster. Is this expected? Can queries only be parallelized when they hit a projection which has been segmented by hash or range? Thanks, Emanuel Pordes