There several GUC settings you can set at a session or query level that can change the number of executors.
Other factors to look at are things like table type and how you set up YARN integration. How is your table distribution set up or table partioning if any? I won't be back to my office until Monday otherwise I could send you additional information. On Thursday, September 29, 2016, Muji Kadry <[email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','[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/ExpandingtheH >> AWQSystem.html#ExpandingtheHAWQSystem-IncreasingSegmentsPerHost. >> Does HAWQ have some utility similar to gpexpand ? >> >> Dominik >> >> > -- Sincerely, Jim Campbell [email protected]
