For hash tables, The number of virtual segments is equal to the bucket number of the table. Bucket number can be specified when creating the table.
On Fri, Jul 1, 2016 at 9:31 AM, Ivan Weng <[email protected]> wrote: > How about hash table? > > On Fri, Jul 1, 2016 at 9:30 AM, Hubert Zhang <[email protected]> wrote: > > > For random table, the virtual segment number is related to the data size > of > > the table. For large tables, we prefer use more virtual segments to > achieve > > better performance. While for small tables, less virtual segments are > > needed, which could save resources and enable more concurrent queries. > > > > On Fri, Jul 1, 2016 at 9:22 AM, yanqing weng <[email protected]> > > wrote: > > > > > Hi HAWQ developer, > > > > > > Elastic execution engine is the important feature in HAWQ 2.0. > > > > > > I have a question for this feature in the HAWQ debugging. Is there > > possible > > > to control the virtual segment number when run query ? If so, which GUC > > or > > > parameter I should set ? Thanks. > > > > > > > > > > > -- > > Thanks > > > > Hubert Zhang > > > -- Thanks Hubert Zhang
