[ https://issues.apache.org/jira/browse/HAWQ-984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Guo updated HAWQ-984: -------------------------- Description: I tried to set a simple guc value via "hawq config" on my centos virtual system, but it spends >6 seconds. I know "hawq config" just simple scp-update xml files to various nodes. This should have been very fast if network situation is fine (My test hawq system is all-in-one test environment so network latency is not an issue.) I expect this is done on my test system (just one seg node) in < 1 second. But actually the time is: $ time hawq config -c lc_messages -v en_US.UTF-8 GUC lc_messages already exist in hawq-site.xml Update it with value: en_US.UTF-8 GUC : lc_messages Value : en_US.UTF-8 real 0m6.363s user 0m0.943s sys 0m1.258s I quickly monitored the processes when running "hawq config", it seems that the scp command finishes very early and adding print debug code in python file gpscp shows that the code in it finishes also very early. I'm not sure if anyone sees that long like my case (my system is probably quite mangled after dev and test). I roughly traced the python stack. I suspect there is something wrong in python or we are not using related module well or we should replace modules. I just checked "hawq config" but it is possible other CLI suffers from this also. was: I tried to set a simple guc value via "hawq config" on my centos virtual system, but it spends >6 seconds. I know "hawq config" just simple scp-update xml files to various nodes. This should have been very fast if network situation is fine (My test hawq system is all-in-one test environment so network latency is not an issue.) I expect this is done on my test system (just one seg node) in < 1 second. But actually the time is: $ time hawq config -c lc_messages -v en_US.UTF-8 GUC lc_messages already exist in hawq-site.xml Update it with value: en_US.UTF-8 GUC : lc_messages Value : en_US.UTF-8 real 0m6.363s user 0m0.943s sys 0m1.258s I quickly monitored the processes when running "hawq config", it seems that the scp command finishes very early and adding print debug code in python file gpscp shows that the code in it finishes also very early. I'm not sure if anyone sees that long like my case (my system is probably quite mangled after dev and test). I roughly traced the python stack. I suspect there is something wrong in python or we are not using related module well or we should replace modules. At least to my limited python knowledge, python subprocess (A suspicious culprit) is quite tricky. I just checked "hawq config" but it is possible other CLI suffers from this also. > hawq config is too slow. > ------------------------ > > Key: HAWQ-984 > URL: https://issues.apache.org/jira/browse/HAWQ-984 > Project: Apache HAWQ > Issue Type: Bug > Components: Command Line Tools > Reporter: Paul Guo > Assignee: Lei Chang > Fix For: backlog > > > I tried to set a simple guc value via "hawq config" on my centos > virtual system, but it spends >6 seconds. I know "hawq config" just > simple scp-update xml files to various nodes. This should have > been very fast if network situation is fine (My test hawq system is all-in-one > test environment so network latency is not an issue.) > I expect this is done on my test system (just one seg node) in < 1 second. > But actually the time is: > $ time hawq config -c lc_messages -v en_US.UTF-8 > GUC lc_messages already exist in hawq-site.xml > Update it with value: en_US.UTF-8 > GUC : lc_messages > Value : en_US.UTF-8 > real 0m6.363s > user 0m0.943s > sys 0m1.258s > I quickly monitored the processes when running "hawq config", > it seems that the scp command finishes very early and adding > print debug code in python file gpscp shows that the code in it > finishes also very early. > I'm not sure if anyone sees that long like my case (my system > is probably quite mangled after dev and test). I roughly traced > the python stack. I suspect there is something wrong in python > or we are not using related module well or we should replace modules. > I just checked "hawq config" but it is possible other CLI suffers from this > also. -- This message was sent by Atlassian JIRA (v6.3.4#6332)