Fix number of threads and amount of concurrency?

I'm developing a UserDefinedTransformFunction and I want to test it out in an environment where the # of threads is fixed.


It seems that the number of threads is a function of the amount of memory, # of cores, amount of data to be processed, and number of partitions. I can understand how the number of partitions sets an upper bound. But I'd still like to be able to test my function in an environment in which 4 threads are being used.


My computer has 16gb of memory, 8 cores, a very small amount of data ~500 rows, partitioned into 4 sets. However, Vertica only creates 1 thread.


I've tried using a resource pool with plannedconcurrency=4 and executionparallelism=4, but Vertica still only uses 1 thread.


Is there any way to set a minimum concurrency? Or to fix the amount of concurrency?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file