[ https://issues.apache.org/jira/browse/HAWQ-587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Radar Lei resolved HAWQ-587. ---------------------------- Resolution: Fixed > Set GUC 'default_hash_table_bucket_number' dynamically > ------------------------------------------------------ > > 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, this should > be changed. > The following is the correct pattern to set > 'default_hash_table_bucket_number': > 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 = > 'hawq_rm_nvseg_perquery_limit' > Some related changes need to be done: > 1. Do not set GUC 'hawq_rm_nvseg_perquery_perseg_limit' any more since the > default value is good enough. > 2. Remove option ''--vsegment-number" since we do not need it any more. > 3. Add new option "--bucket_number" to let user define GUC > 'default_hash_table_bucket_number'. -- This message was sent by Atlassian JIRA (v6.3.4#6332)