[jira] [Assigned] (HAWQ-587) Set GUC 'default_hash_table_bucket_number' value not more than 512

["Radar Lei (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Radar Lei reassigned HAWQ-587:
------------------------------

    Assignee: Radar Lei  (was: Lei Chang)

> Set GUC 'default_hash_table_bucket_number' value not more than 512
> ------------------------------------------------------------------
>
>                 Key: HAWQ-587
>                 URL: https://issues.apache.org/jira/browse/HAWQ-587
>             Project: Apache HAWQ
>          Issue Type: Improvement
>          Components: Command Line Tools
>            Reporter: Radar Lei
>            Assignee: Radar Lei
>
> Currently we set default_hash_table_bucket_number  = 6 * #nodes
> The following is the correct one.
> 1) If #nodes <= 85, default_hash_table_bucket_number  = 6 * #nodes
> 2) if #nodes > 85 and #nodes <= 102, default_hash_table_bucket_number  = 5 * #nodes
> 3) if #nodes > 102 and #nodes <= 128, default_hash_table_bucket_number = 4 * #nodes
> 4) if #nodes > 128 and #nodes <= 170, default_hash_table_bucket_number = 3 * #nodes
> 5) if #nodes > 170 and #nodes <= 256, default_hash_table_bucket_number = 2 * #nodes
> 6) if #nodes > 256 and #nodes <= 512, default_hash_table_bucket_number = 1 * #nodes
> 7) if #nodes > 512, default_hash_table_bucket_number = 512



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)