From: | "movead(dot)li(at)highgo(dot)ca" <movead(dot)li(at)highgo(dot)ca> |
---|---|
To: | "Etsuro Fujita" <etsuro(dot)fujita(at)gmail(dot)com>, Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
Cc: | "Justin Pryzby" <pryzby(at)telsasoft(dot)com>, "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>, "Ahsan Hadi" <ahsan(dot)hadi(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Asynchronous Append on postgres_fdw nodes. |
Date: | 2020-11-26 01:28:06 |
Message-ID: | 2020112609280420453319@highgo.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kasahara Tatsuhito | 2020-11-26 01:41:03 | Re: autovac issue with large number of tables |
Previous Message | Peter Geoghegan | 2020-11-26 01:00:31 | Re: Deleting older versions in unique indexes to avoid page splits |