[
https://issues.apache.org/jira/browse/HAWQ-587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Radar Lei updated HAWQ-587:
---------------------------
Description:
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 =
'hawq_rm_nvseg_perquery_limit'
was:
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
> 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
> 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 =
> 'hawq_rm_nvseg_perquery_limit'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
