I test the patch and occur several issues as blow: Issue one: Get a Assert error at 'Assert(bms_is_member(i, node->as_needrequest));' in ExecAppendAsyncRequest() function when I use more than two foreign table on different foreign server.
I research the code and do such change then the Assert problom disappear. @@ -1004,6 +1004,7 @@ ExecAppendAsyncResponse(AsyncRequest *areq) bms_del_member(node->as_needrequest, areq->request_index); node->as_asyncpending = bms_add_member(node->as_asyncpending, areq->request_index); + node->as_lastasyncplan = INVALID_SUBPLAN_INDEX; return false; } Issue two: Then I test and find if I have sync subplan and async sunbplan, it will run over the sync subplan then the async turn, I do not know if it is intent. Issue three: After code change mentioned in the Issue one, I can not get performance improvement. I query on partitioned table and all sub-partition the time spent on partitioned table always same as the sum of all sub-partition. Sorry if I have something wrong when test the patch. Regards, Highgo Software (Canada/China/Pakistan) URL : www.highgo.ca
