Vertica_Curtis
Employee
Vertica_Curtis Employee
Reactions
-
Re: Node Dependencies, not including unsegmented projections
select get_node_dependencies('1110') will show you the projections that are aligned in that way. There are 4 of them. Looks like you have some projections that were built as Ksafe=2. You can drop the… (View Post)1 -
Re: EXECUTIONPARALLELISM in resource Pool
ExecutionParallelism is a pretty edge-case tuning knob. It's just as likely to hurt a query as help it, and even then, you're not likely to see significant differences in performance one way or the o… (View Post)1 -
Re: understanding Maxconcurrency and Parallelism
We're probably over-thinking this. ExecutionParallelism defaults to the # of cores. It is the maximum number of parallel threads that a query can use while executing. Setting it lower can restrict th… (View Post)1 -
Re: understanding Maxconcurrency and Parallelism
Wow, 128 cores is a lot! The MaxConcurrency value caps the number of queries in that pool. It has nothing to do with cores. Resource pools provide a way of prioritizing tasks by type, or restricting … (View Post)1 -
Re: Partitioning and Loading
300 partitions probably isn't a huge number of partitions. But certainly less is generally better. I tend to believe the documentation takes a very conservative stance here. Having a projection which… (View Post)1