Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eWP2C-0002L1-LI for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jan 2018 16:03:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eWP2B-0007S4-TC for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jan 2018 16:03:23 +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 1eWP2B-0007Ru-JW for pgsql-hackers@lists.postgresql.org; Tue, 02 Jan 2018 16:03:23 +0000 Received: from smtprelay0191.b.hostedemail.com ([64.98.42.191] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eWP28-0000qN-TR for pgsql-hackers@postgresql.org; Tue, 02 Jan 2018 16:03:22 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay04.b.hostedemail.com (Postfix) with ESMTP id 81B9F7B852; Tue, 2 Jan 2018 16:03:19 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::::::::::,RULES_HIT:41:355:379:599:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1540:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2560:2563:2682:2685:2828:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3352:3865:3867:3870:3871:3872:3873:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4605:5007:6261:9025:9121:10004:10394:10400:10848:11232:11658:11914:12663:12740:12895:13069:13311:13357:13439:13894:13895:14721:14764:21080:21627:30029:30030:30054:30070:30083,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:2,LUA_SUMMARY:none X-HE-Tag: hot28_9129bc4b08b3c X-Filterd-Recvd-Size: 1936 Received: from alvin.alvh.no-ip.org (unknown [179.57.113.18]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf02.b.hostedemail.com (Postfix) with ESMTPA; Tue, 2 Jan 2018 16:03:17 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id B2EE47CC; Tue, 2 Jan 2018 13:03:13 -0300 (-03) Date: Tue, 2 Jan 2018 13:03:13 -0300 From: Alvaro Herrera To: Jesper Pedersen Cc: Robert Haas , David Rowley , Simon Riggs , Pg Hackers , Maksim Milyutin Subject: Re: [HACKERS] Proposal: Local indexes for partitioned table Message-ID: <20180102160313.aslhjfbecv65usvb@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Jesper Pedersen wrote: > On 12/22/2017 10:10 AM, Alvaro Herrera wrote: > > If you have wording suggestions for the doc changes, please send them > > along. > > Maybe we should make the default index name more explicit under the 'name' > parameter as attached. I'm -0.2 on documenting this. In general, I'm hesitant to promise more than strictly needed, mostly because it's more difficult to later change our minds. For example, what if soon after this patch we decide to invent a new mechanism for creating names on partitions? Also, in reality there are additional considerations (how do we truncate very long names, what do we do if the name is already taken) that I would rather not ossify in user-facing documentation. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services