Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZTrGg-0005ac-0c for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Aug 2015 12:54:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZTrGf-0001uZ-Dz for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Aug 2015 12:54:29 +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 1ZTrFN-0000SS-A2 for pgsql-hackers@postgresql.org; Mon, 24 Aug 2015 12:53:09 +0000 Received: from relay2-d.mail.gandi.net ([217.70.183.194]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZTrFL-0002mq-EJ for pgsql-hackers@postgresql.org; Mon, 24 Aug 2015 12:53:08 +0000 Received: from mfilter22-d.gandi.net (mfilter22-d.gandi.net [217.70.178.150]) by relay2-d.mail.gandi.net (Postfix) with ESMTP id 85D8FC5A54; Mon, 24 Aug 2015 14:53:06 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mfilter22-d.gandi.net Received: from relay2-d.mail.gandi.net ([IPv6:::ffff:217.70.183.194]) by mfilter22-d.gandi.net (mfilter22-d.gandi.net [::ffff:10.0.15.180]) (amavisd-new, port 10024) with ESMTP id ltB9RWfKnMYG; Mon, 24 Aug 2015 14:53:05 +0200 (CEST) X-Originating-IP: 98.122.164.227 Received: from [192.168.10.146] (unknown [98.122.164.227]) (Authenticated sender: adsend@dunslane.net) by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id 54902C5A46; Mon, 24 Aug 2015 14:53:03 +0200 (CEST) Subject: Re: Declarative partitioning To: Simon Riggs , Josh Berkus References: <55D3093C.5010800@lab.ntt.co.jp> <55D36BFA.7080004@agliodbs.com> <55D7EDBD.50008@BlueTreble.com> <55DA5CF2.5080207@agliodbs.com> Cc: Jim Nasby , Amit Langote , Pg Hackers From: Andrew Dunstan Message-ID: <55DB13AD.1060808@dunslane.net> Date: Mon, 24 Aug 2015 08:53:01 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.1.0 MIME-Version: 1.0 In-Reply-To: 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 On 08/24/2015 03:46 AM, Simon Riggs wrote: > > > ALTER TABLE foo ADD PARTITION NEXT; > > when a sequence of partitions has been defined > > Or perhaps ALTER TABLE foo ADD PARTITION NEXT nn; So you can set up, say, a week's worth of daily partitions at once. I could also imagine a variant that allows you to specify partitions up to the one including some value. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers