Hi Dominik, You can increase the parallelism by increasing the virtual segment limit and segment memory for the cluster (using Ambari) and for each query example below.
postgres=# set hawq_rm_stmt_vseg_memory='256mb';SETpostgres=# set hawq_rm_stmt_nvseg=10;SETpostgres=# create table t(i integer);CREATE TABLEpostgres=# insert into t values(1);INSERT 0 1 ​Regards, Muji On Thu, Sep 29, 2016 at 8:12 AM, Dominik Choma <[email protected]> wrote: > Hi all, > > I want to increase parallelism level and hardware utilization by > increasing number of segments per host. In PHD it can be done via gpexpand > http://pivotalhd-210.docs.pivotal.io/doc/2010/ExpandingtheHAWQSystem.html# > ExpandingtheHAWQSystem-IncreasingSegmentsPerHost. > Does HAWQ have some utility similar to gpexpand ? > > Dominik > >
