Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cobph-000343-K0 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Mar 2017 20:17:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cobph-0001f2-6i for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Mar 2017 20:17:13 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cobpe-0001cb-HS for pgsql-hackers@postgresql.org; Thu, 16 Mar 2017 20:17:10 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cobpc-0001qK-J3 for pgsql-hackers@postgresql.org; Thu, 16 Mar 2017 20:17:09 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id v2GKH3m8022645; Thu, 16 Mar 2017 16:17:03 -0400 From: Tom Lane To: Corey Huinker cc: Amit Langote , Kyotaro HORIGUCHI , robertmhaas@gmail.com, amitdkhan.pg@gmail.com, pgsql-hackers@postgresql.org Subject: Re: asynchronous execution In-reply-to: References: <9058d70b-a6b0-8b3c-091a-fe77ed0df580@lab.ntt.co.jp> <20170216.210600.214980879.horiguchi.kyotaro@lab.ntt.co.jp> <20170222.173945.262776579.horiguchi.kyotaro@lab.ntt.co.jp> <20170223.205925.120810176.horiguchi.kyotaro@lab.ntt.co.jp> <7847e2c8-2d8b-c692-4e0b-2544887ba606@lab.ntt.co.jp> Comments: In-reply-to Corey Huinker message dated "Thu, 16 Mar 2017 13:03:21 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <22643.1489695423.1@sss.pgh.pa.us> Date: Thu, 16 Mar 2017 16:17:03 -0400 Message-ID: <22644.1489695423@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Corey Huinker writes: > I reworked the test such that all of the foreign tables inherit from the > same parent table, and if you query that you do get async execution. But It > doesn't work when just stringing together those foreign tables with UNION > ALLs. > I don't know how to proceed with this review if that was a goal of the > patch. Whether it was a goal or not, I'd say there is something either broken or incorrectly implemented if you don't see that. The planner (and therefore also the executor) generally treats inheritance the same as simple UNION ALL. If that's not the case here, I'd want to know why. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers