Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZSzZq-0007pF-Iw for pgsql-hackers@arkaria.postgresql.org; Sat, 22 Aug 2015 03:34:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZSzZo-0003Hp-KN for pgsql-hackers@arkaria.postgresql.org; Sat, 22 Aug 2015 03:34:40 +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 1ZSzZm-0003Hg-Ug for pgsql-hackers@postgresql.org; Sat, 22 Aug 2015 03:34:39 +0000 Received: from mail-by2on0075.outbound.protection.outlook.com ([207.46.100.75] helo=na01-by2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZSzZh-0005DW-9Q for pgsql-hackers@postgresql.org; Sat, 22 Aug 2015 03:34:37 +0000 Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:fd66:ff64:4035:72ff) by CY1PR11MB0681.namprd11.prod.outlook.com (10.163.236.19) with Microsoft SMTP Server (TLS) id 15.1.243.23; Sat, 22 Aug 2015 03:34:27 +0000 Subject: Re: Declarative partitioning To: Josh Berkus , Amit Langote , Pg Hackers References: <55D3093C.5010800@lab.ntt.co.jp> <55D36BFA.7080004@agliodbs.com> From: Jim Nasby Message-ID: <55D7EDBD.50008@BlueTreble.com> Date: Fri, 21 Aug 2015 22:34:21 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.1.0 MIME-Version: 1.0 In-Reply-To: <55D36BFA.7080004@agliodbs.com> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:fd66:ff64:4035:72ff] X-ClientProxiedBy: DM2PR0501CA0037.namprd05.prod.outlook.com (25.162.29.175) To CY1PR11MB0681.namprd11.prod.outlook.com (25.163.236.19) X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0681; 2:Mu9WCBYxhWrdtgtn48NLH+0DUCXRLX5mlubnM7fScR/k3JyrTkhOn8WcSO94tppSSkgi2IPCggn/bC62Mostc1QJo8drpT9ztEC/YljzcV7Zx2USmEtTbGsHoqSmS1Crp/xdr1EJ56Sdb2Z0f6FjmvI5R8M11Ag0IaHkKdkkrLc=; 3:u1LTsdIdiT6TaSo1I7hPbr9hr7v+8EmyVwlyKVYLXQUjUGRhP0bt3sEq4j5yQGodj7pnLkJ74eXLK5OiZHglwslBXvZiBYWr/2sMGKrWTLT+by+YV19RR28MCOc+a5kta+D2N9OKfvc78VF1w5pzxQ==; 25:6NDzSwZ/N4H6znwLDOYk/Z4RVwGYNSmEDCVa+NP2gUJOipATmC2KtJ43mNsDxAWB8T+su7HOGMnOqRdywvuvvAayMIXijzQpT74ANyQuxxt9Ztbij/Es3IA4IK9DfnCgJtnI1MtFBlyST4c2yGC5IZervKiFgE/eypsVQMrI6kaDBuujlUEJ/ZceFCYIGrzg6JbA4eBj43FpRzJESnojfn2o//JQB7r8wchzRQR0/BJqN/0NQEzd/5CSevVD2s2GlSxHoNLsMMtUjzoOWol5sw==; 4:RdSfIpBufhNM7enPEd2UYjS1HJT3BYj/UbWZDOaJRJ5eydJMPebkjnJOfQhppuElt2ZvBM/tspEZlMWaiEpu6D/HBu9mrS0yAox7oWbMwTnX1a5F/wfKLE5gcX31zfzsRGWMdpfMfN2e1/5AZgG+rgMxl7L3zclHXDan8H/fOfOH0RrKnW3LdyY/jkhpJ/cjzWkldzu2xpkxIPl/lFUImaBEV4l+WyPhOoEN4T7DpEULamCOVC8+iJGWKPN5O0nKYALhSmK7yfR4QPKrpSj+3mvEJi/cW0BR3ldcBg+zPPztGMKa4TSYXsjeDVuD4GUa X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY1PR11MB0681; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(5005006)(8121501046)(3002001); SRVR:CY1PR11MB0681; BCL:0; PCL:0; RULEID:; SRVR:CY1PR11MB0681; X-Forefront-PRVS: 0676F530A9 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(189002)(24454002)(199003)(377454003)(479174004)(5001830100001)(23676002)(42186005)(36756003)(83506001)(40100003)(97736004)(122386002)(5001860100001)(62966003)(47776003)(65956001)(105586002)(53416004)(81156007)(64126003)(65806001)(5001960100002)(69596002)(107886002)(189998001)(77156002)(4001350100001)(33656002)(4001540100001)(5004730100002)(106356001)(86362001)(87976001)(5001770100001)(46102003)(65816999)(76176999)(15975445007)(50466002)(19580395003)(50986999)(101416001)(64706001)(54356999)(2950100001)(5007970100001)(68736005)(77096005)(92566002)(3826002)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:CY1PR11MB0681; H:decina.attlocal.net; FPR:; SPF:None; PTR:InfoNoRecords; MX:1; A:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtDWTFQUjExTUIwNjgxOzIzOjNZY3RROU1qeWF1Zzg1cTFSeHdDeGVFUjFa?= =?utf-8?B?NDA2SmNtSWh2enozSjkwOTh3Ly9KZHhhbUxDSk12OGdNNEZhVmRFaURZVGpO?= =?utf-8?B?d3BIQTZjbXNkcG16OEV1R0ZHa1dUa3FnY1FubnF6Yzk3L2JLZDhjeElLeHRw?= =?utf-8?B?dWo5SmkybDZJamJoaUdFR1phSzMwNW5BNERROE9YdEthaW8yRTloWWFwVndE?= =?utf-8?B?MkZ3NllZMFhTK1ZGWnl2cm5leXh3TTh6TXl2eHBITlpFVmtiRkpDcDdsWjNs?= =?utf-8?B?QTlQcm8wWHhEOUhTN1hRNk45Qit1MndFVCttU3B3b2taeFJXRVBtRzMrMGRC?= =?utf-8?B?aVlJZVJXY2d1QmRKdlBzZlpreFVRd1FJalFtSHVSQWlrVmx5ZldXcTVvdVpw?= =?utf-8?B?VWFxMSt4TWd6SjgwRHVWYmU3d2ozbTgvOERSdERqTTdkNmhwSnB6ekxRd1NO?= =?utf-8?B?cHd1UnErSEhUUjlrRkh2RjdYMjVEdWtVT0Q4VWxKTzJ2RGFUSDdmcHJvNStU?= =?utf-8?B?ajN4c0hsdFVSU1FoYldzeWptT3NMWURzcGdZdURYdkZYSlZZK3JzaTFOVzd4?= =?utf-8?B?L0pmOFdJMkRUTHc5Mk16QmJKei9WNS9rWTFCYUd0cG9QTWUzcjZOa1dnS2ln?= =?utf-8?B?cUszL2ZabXFRSDM2L0FoNzZJNUZhSU1TU29HMjhhN2hTLzZTdXBjTTdPcDFi?= =?utf-8?B?OStQb0k4VWp3RW5UcE1lMjNMMTR4UFo4V1orYTlLNjRkUXBxSVJ5b0xzREU4?= =?utf-8?B?a1hYT2ExcFZvM0RLc3Y4SG5xYWdQdHVDU09yS2RTTzZ1ajdqTW1kS0QzOHk3?= =?utf-8?B?WS9EcjBnd1dXVkx0eU9jdUhpVkY3U2JDUldkQ2NaTW5IaUdSd3p6bHVsaElW?= =?utf-8?B?ZTd6elJ0Q3ZxV2dKQ011dkVyanN5NnZjMExxeWtvYjZ0bk42TW5sd1FlWkh2?= =?utf-8?B?YVhkdHQ1dFhHS242U28zT0M4OTVoc3c5UG9YUzB5QUdlQ01Ib3BsdXhXOEVC?= =?utf-8?B?YTZJb3NwaTM0ekJUeVdBVVExbGxqaVJFdUZNNFgvS3JJNUk4d0FoYWFreTEy?= =?utf-8?B?OHlmUW1zSHRmUjRpcFFFamNNN05jN3FoRzVBTEE5L2cwdWoxdldUY01UWjZq?= =?utf-8?B?a2tkRUZYcUxoYzJEc1dmMm9oRno3QUNnRTZjaUJ5QnUvVWQ5OVU0WnlROUdv?= =?utf-8?B?YUM1Y2hQVnVlMDFRaFYwUDdreXZOaTFRelEzdW1lMTdFclQ2Z3U1MkNObjRR?= =?utf-8?B?NHlxWFdXU3JtekhDMks3TU1OSUczak92RUJpaVpSRVZFN0VMWmZNaVB1M3VQ?= =?utf-8?B?eDZhaEtvVU9OSUc2MlNUWG53eldVdTJwZGlTQjdnbVhORm16dXF3L1RzNytv?= =?utf-8?B?NWV4b3RhZVI1bDNlQmVJQUtJTTNuckZjcEdWOHZKSCtkYWwzQXBSejBqR1k2?= =?utf-8?B?SXc4cFlnbm8vdUNIZlE0VkxwR1ROTHZSZzNxY3gxMi9hNkFxOE1YSWFXeG5N?= =?utf-8?B?andxVHY5MDdjQ1FFRTVzeGdVVjlzRHpiQjUveWhiZXJnSE1QOCtpSUc2UHhS?= =?utf-8?B?d1ZhY3ZybTh6cUJXdzRUZ3N3UlFOd3ZXUXdweEVDWXNCMmNvbW5xRURid2JF?= =?utf-8?B?QXIyczJ0QS9TVXlRSHAweTJYTjNIdVF1MEQza3pydi90TXdrakpqR3REclpu?= =?utf-8?B?ZXhKa25EWlFsTjFzTFZFSkZtdDVieHRBd0hIZndKK1laTTI0a3UxV3haN0NM?= =?utf-8?B?dW8xU2s2dHQ2eWYxRzYrdzBxYWVRYzdObTRvTDR0WjJDS0VjY2tyY3BEY3M5?= =?utf-8?B?aFU3S3JBa1VtdDJlV0hySEJSa0cyblhvWkJaaTltSlJ4RnhIQWsxbWFvbWhG?= =?utf-8?B?SDdFNGZXWEZadmwrNEovbzRpbEFGbFBmRXdIaEM5WjBlYkhnWmtLQm9mRkhs?= =?utf-8?B?cHBnTWY3d2diNFp6enViaHJoZUZMNnhjaDlzL1R3TzM4QUI3ZHlOQlJ2dWE1?= =?utf-8?Q?NMuq6F?= X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0681; 5:HqniWoZZs7UvtSKeKQlCoaT3A9xRiwXkdTmEPQ9elV23PdcdPxduTf3Ka9ZdIh1i3MQPWrjkP3NzGx+6lHr2XJkcVQxssc2+N3BVyQtckbh/ES3glvsOnYrKaRxw56PIaMI+ad9ejj+0IpbrTP6STw==; 24:cEEypWBmdnpFqyKPCm6gHOMyXSquqL9A+ha41yl6upi/u7e1Z3uMiPVOEt+5GoSoj45mfa2G2fKgxnOsMDth6osdgfo6O9ijaBUJDPewTS0=; 20:s1i9hoLSXqV0FRfd4Z/HewoFT+DpPQns2e8XCqvpwgZhuDfeog1DhgVwjHGSofAiY33+PQuWs25+3Q0xirIRhg== SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Aug 2015 03:34:27.3986 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR11MB0681 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 8/18/15 12:31 PM, Josh Berkus wrote: > Also this would be useful for range > partitions: > > CREATE PARTITION ON parent_table USING ( start_value ); > > ... where start_value is the start range of the new partition. Again, > easier for users to get correct. Instead of that, I think it would be more foolproof to do CREATE PARTITION ON parent_table FOR ( value1, ... ); instead of trusting the user to get the exact start value correct. Though... I guess there could be value in allowing an exact start value but throwing an error if it doesn't sit exactly on a boundary. Might make it less likely to accidentally create the wrong partition. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers