You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by zhangh43 <gi...@git.apache.org> on 2016/06/23 04:51:49 UTC
[GitHub] incubator-hawq pull request #745: HAWQ-850. Planner supports refineCachedPla...
GitHub user zhangh43 opened a pull request:
https://github.com/apache/incubator-hawq/pull/745
HAWQ-850. Planner supports refineCachedPlan interface.
in PBE(prepare bind execution) cases, plan will be cached, and only be generated once in postgres.
But in HAWQ since resource is dynamic or elastic, the plan maybe changed during the different execution of PBE. Also, the file split allocation result which is stored in plan is dynamically too, so the split-vseg mapping may also be changed.
For example, We call a plpgsql function which do "insert into t select * from t".
in Prepare we cache the plan, with fixed split-vseg mapping(e.g. 10 blocks), but after insert, there would be 20 blocks so the old split-vseg mapping is invalid. We need to update it. Also when we call this function again and again, the data size of t may request more resource to handle it than the first call, so we should recalculate the entire plan with the new vseg number.
This function is implemented in a interface called refineCachedPlan.
[Link to Jira](https://issues.apache.org/jira/browse/HAWQ-850)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zhangh43/incubator-hawq hawq850
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/745.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #745
----
commit ee4cdf7a694ccf62f0548dd0a52ddb874f9976dd
Author: hzhang2 <zh...@163.com>
Date: 2016-06-22T06:36:51Z
HAWQ-850. Planner supports refineCachedPlan interface.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-hawq issue #745: HAWQ-850. Planner supports refineCachedPlan inter...
Posted by wengyanqing <gi...@git.apache.org>.
Github user wengyanqing commented on the issue:
https://github.com/apache/incubator-hawq/pull/745
LGTM
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-hawq issue #745: HAWQ-850. Planner supports refineCachedPlan inter...
Posted by ictmalili <gi...@git.apache.org>.
Github user ictmalili commented on the issue:
https://github.com/apache/incubator-hawq/pull/745
LGTM
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---