Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f4o5q-0008Uh-3j for pgsql-hackers@arkaria.postgresql.org; Sat, 07 Apr 2018 13:41:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f4o5p-0002IH-22 for pgsql-hackers@arkaria.postgresql.org; Sat, 07 Apr 2018 13:41:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f4o5o-0002I7-R9 for pgsql-hackers@lists.postgresql.org; Sat, 07 Apr 2018 13:41:20 +0000 Received: from new1-smtp.messagingengine.com ([66.111.4.221]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f4o5l-0006cG-Ac for pgsql-hackers@postgresql.org; Sat, 07 Apr 2018 13:41:20 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailnew.nyi.internal (Postfix) with ESMTP id 9A92BB2F; Sat, 7 Apr 2018 09:41:15 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sat, 07 Apr 2018 09:41:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=+axl/WdoR07LR7vcG 5q16ekPJrXDPJ5N9i6fpJLPVy4=; b=hjF48b0s7uXFgkgSmcLyGe9NuC7koivPl tdVHsCXN0HsGY3qxmdMWxN/JwVfmPPbbrbOdAQxcwxVJnEq8/dvFqTOPwP+FJ1aO JnqtIYuYMiIkhASRMsv3jPyT/b8mNfVGu0A17dvCtzDlku4jAYuAZm/03eIW8nss ogY4EUqH3rCG6BxUcggjzT/xu1ASKJzwn/Vt/pEI6VhOPlnm5bYD3aW9WEIs9UsY MDC8MpWwZDT0scAOym9BP685qAzmr2YBcDn5kPnpcio0HhbJzXzM+Ch4q7UPBJO0 rxZyH/v+cCJW5oMvknq2PjRLzACA3wHAW49/BeVmJ8lxwxPh+0WYw== X-ME-Sender: Received: from alvin.alvh.no-ip.org (unknown [179.56.51.182]) by mail.messagingengine.com (Postfix) with ESMTPA id 5D937E43C8; Sat, 7 Apr 2018 09:41:14 -0400 (EDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 7455533C; Sat, 7 Apr 2018 10:41:12 -0300 (-03) Date: Sat, 7 Apr 2018 10:41:12 -0300 From: Alvaro Herrera To: David Rowley Cc: Amit Langote , Andres Freund , Amit Langote , Jesper Pedersen , Rajkumar Raghuwanshi , Beena Emerson , Robert Haas , amul sul , "pgsql-hackers@postgresql.org" , Dilip Kumar Subject: Re: [HACKERS] Runtime Partition Pruning Message-ID: <20180407134112.t47gnrnzxakeppeb@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk David Rowley wrote: > On 8 April 2018 at 01:18, Alvaro Herrera wrote: > > Amit had it as "indexes" also in his original. I wanted to avoid using > > the "indexes" word alone, whose meaning is so overloaded. > > hmm, good point. > > > How about this? > > "... which are then executed to produce a set of partitions (as indexes > > of resultRelInfo->part_rels array) that satisfy the constraints in the > > step". > > Works for me, but with RelOptInfo rather than resultRelInfo. Oops, sorry about that. Pushed now, adding one line to get_matching_partitions also. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services