Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a0w7m-0000U9-2q for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Nov 2015 18:46:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a0w7l-0006ny-Lr for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Nov 2015 18:46:01 +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 1a0w6P-0004Ed-To for pgsql-hackers@postgresql.org; Mon, 23 Nov 2015 18:44:37 +0000 Received: from out.smtp-auth.no-ip.com ([8.23.224.60]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1a0w6L-0008HN-2v for pgsql-hackers@postgresql.org; Mon, 23 Nov 2015 18:44:37 +0000 X-No-IP: alvh.no-ip.org@noip-smtp X-Report-Spam-To: abuse@no-ip.com Received: from alvin.alvh.no-ip.org (unknown [200.104.53.52]) (Authenticated sender: alvh.no-ip.org@noip-smtp) by smtp-auth.no-ip.com (Postfix) with ESMTPA id 159C9400E57; Mon, 23 Nov 2015 10:44:25 -0800 (PST) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 17BF113BD; Mon, 23 Nov 2015 15:44:22 -0300 (CLT) Date: Mon, 23 Nov 2015 15:44:22 -0300 From: Alvaro Herrera To: Robert Haas Cc: Amit Langote , Simon Riggs , Amit Langote , "pgsql-hackers@postgresql.org" Subject: Re: Declarative partitioning Message-ID: <20151123184422.GA4073@alvherre.pgsql> References: <55D3093C.5010800@lab.ntt.co.jp> <20150826140158.3678.53116.pgcf@coridan.postgresql.org> <563341AE.5010207@lab.ntt.co.jp> <564EE560.60106@lab.ntt.co.jp> <20151120114446.GN614468@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: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -2.6 (--) 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 Robert Haas wrote: > I support building incrementally, but I don't see why we want to > change the catalog structure and then change it again. That seems > like it makes the project more work, not less. I agree with what you say. I thought you were saying that the implementation had to provide multi-partitioning from the get-go, not just the design. > To me, it seems like there is a pretty obvious approach here: each > table can be either a plain table, or a partition root (which can look > just like an empty inheritance parent). Then multi-level partitioning > falls right out of that design without needing to do anything extra. Sounds reasonable. > I think it is also worth getting the syntax right from the beginning. Yes, that's critical. We could implement the whole thing in gram.y and then have the unsupported cases throw errors; then it's easy to see that there are no grammar conflicts to deal with later. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers