Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aa9cL-0001cB-QZ for pgsql-hackers@arkaria.postgresql.org; Sun, 28 Feb 2016 22:15:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aa9cK-0001v4-HQ for pgsql-hackers@arkaria.postgresql.org; Sun, 28 Feb 2016 22:15:08 +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.84) (envelope-from ) id 1aa9cI-0001tl-HS for pgsql-hackers@postgresql.org; Sun, 28 Feb 2016 22:15:06 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aa9cB-0005tG-7S for pgsql-hackers@postgresql.org; Sun, 28 Feb 2016 22:15:06 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id E16A621C667F for ; Mon, 29 Feb 2016 01:14:57 +0300 (MSK) 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 WJgtgTUJjV9j for ; Mon, 29 Feb 2016 01:14:56 +0300 (MSK) Received: from zilders-MacBook-Pro.local (ppp79-139-136-145.pppoe.spdop.ru [79.139.136.145]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 54AFE21C6676 for ; Mon, 29 Feb 2016 01:14:56 +0300 (MSK) Subject: Re: Declarative partitioning To: pgsql-hackers@postgresql.org References: <55D3093C.5010800@lab.ntt.co.jp> <56A23484.4000504@2ndquadrant.com> <56A9D51E.2000508@lab.ntt.co.jp> <56C1302D.6070403@lab.ntt.co.jp> <56C26D27.40108@lab.ntt.co.jp> <56C28C4C.5090409@agliodbs.com> <56C28D8A.2060608@lab.ntt.co.jp> From: Ildar Musin Message-ID: <56D3715F.1060102@postgrespro.ru> Date: Mon, 29 Feb 2016 03:14:55 +0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: <56C28D8A.2060608@lab.ntt.co.jp> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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 16/02/16 07:46, Amit Langote wrote: > Hi Josh, > > On 2016/02/16 11:41, Josh berkus wrote: >> On 02/15/2016 04:28 PM, Amit Langote wrote: >>> Also, you won't see any optimizer and executor changes. Queries will still >>> use the same plans as existing inheritance-based partitioned tables, >>> although as I mentioned, constraint exclusion won't yet kick in. That will >>> be fixed very shortly. >> We're not going to use CE for the new partitioning long-term, are we? This >> is just the first version, right? > Yes. My approach in previous versions of stuffing major planner changes in > with the syntax patch was not quite proper in retrospect. So, I thought > I'd propose any major planner (and executor) changes later. > > Thanks, > Amit > Hello Amit, Thank you for your work. I'm currently working on extension aimed at planner optimization for partitioned tables (https://github.com/postgrespro/pg_pathman). At this moment I have an implementation of binary search for range partitioned tables with basic partitioning keys (date, timestamp, integers etc). And I'd like to try to combine your syntax and infrastructure with my binary search implementation. There likely will be changes in range syntax and partitions cache structure based on discussion. So looking forward for your next patch. Ildar -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers