Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cF1Mc-0002Km-PK for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Dec 2016 16:16:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cF1Mc-0006Sj-D8 for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Dec 2016 16:16:06 +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 1cF1Mb-0006Pg-1n; Thu, 08 Dec 2016 16:16:05 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cF1MX-0006S1-UC; Thu, 08 Dec 2016 16:16:03 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id CD8AC21C5308; Thu, 8 Dec 2016 19:15:59 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id sp5AUeVpPiG4; Thu, 8 Dec 2016 19:15:59 +0300 (MSK) Received: from localhost (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 9027B21C52C3; Thu, 8 Dec 2016 19:15:59 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1481213759; bh=HR3Ls301cGMTu04/dJO+CEXfTsReg42Fvj2YYckJyUg=; h=From:To:Cc:Subject:Date:In-Reply-To:References; b=TAGbp259HEwV9PubLI0B3Sd7IsbS4LckUAwgj5DfkGwK95ajlIS+8z/AHtl4mH8eK DgfB4wdvNqzEs4BZsHGsKIirO07hRQ+68hl1qgEoFhOnNy8euP4iRdcFNriWiMRYyK +ADbd5aYyjhjKwK349JwptE3Gsmon5iMCMZuDrxo= From: Dmitry Ivanov To: Robert Haas Cc: Michael Paquier , Andres Freund , Erik Rijkers , Amit Langote , Amit Langote , Rajkumar Raghuwanshi , Ashutosh Bapat , Pg Hackers , Subject: Re: Declarative partitioning - another take Date: Thu, 08 Dec 2016 19:13:44 +0300 MIME-Version: 1.0 Message-ID: <426b2b01-61e0-43aa-bd84-c6fcf516f1c3@postgrespro.ru> In-Reply-To: References: <890ce68d-2cff-ccf3-67f7-6f5d3264dbfc@lab.ntt.co.jp> <78ae9888-7372-245d-cf6b-f655e6fe6c12@lab.ntt.co.jp> <20161208043942.ekjvyf7ddbxehh7c@alap3.anarazel.de> Organization: Postgres Professional User-Agent: Trojita/0.7; Qt/5.7.0; xcb; Linux; Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -5.0 (-----) 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 Hi everyone, > Of course, this is the beginning, not the end. I've been thinking > about next steps -- here's an expanded list: > - more efficient plan-time partition pruning (constraint=20 > exclusion is too slow) > - run-time partition pruning > - try to reduce lock levels > ... We (PostgresPro) have been working on pg_pathman for quite a while, and=20 since it's obviously going to become the thing of the past, it would be a=20 wasted effort if we didn't try to participate. For starters, I'd love to work on both plan-time & run-time partition=20 pruning. I created a custom node for run-time partition elimination, so I=20 think I'm capable of developing something similar. --=20 Dmitry Ivanov Postgres Professional: http://www.postgrespro.com Russian Postgres Company --=20 Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers