Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cjG3x-0001oR-S3 for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Mar 2017 02:01:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cjG3x-0001VL-Eq for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Mar 2017 02:01:49 +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_2) (envelope-from ) id 1cjFsz-0003X4-Iq for pgsql-hackers@postgresql.org; Thu, 02 Mar 2017 01:50:29 +0000 Received: from mail-cys01nam02on0054.outbound.protection.outlook.com ([104.47.37.54] helo=NAM02-CY1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cjFsw-0001TU-VZ for pgsql-hackers@postgresql.org; Thu, 02 Mar 2017 01:50:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=PNTiPLS+1ioIp3X0S42SuWKm6VJO9J/gNFZ4IOnW0aI=; b=IMP6kOelw/XPuTZoMhqOSp4nH6nvy+rNZxH3QBrO5KKVdleUV7Rx3EPx00CnNGxdr39kQ5WS58KEI/aKs6J5dUfIg9mWP4gPSfp8V/mnqFq3CzPtIXL/jk6WuM47tMSMJSl9oDAl2rJy+VKFW3NdIzluJttU4iahUWsFaxc8YBc= Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.local (24.205.140.236) by BN6PR11MB1636.namprd11.prod.outlook.com (10.172.24.9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.933.12; Thu, 2 Mar 2017 01:50:23 +0000 Subject: Re: REINDEX CONCURRENTLY 2.0 To: Andreas Karlsson , Michael Paquier , PostgreSQL mailing lists References: From: Jim Nasby Message-ID: Date: Wed, 1 Mar 2017 19:25:23 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.7.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [24.205.140.236] X-ClientProxiedBy: MWHPR1201CA0018.namprd12.prod.outlook.com (10.174.253.28) To BN6PR11MB1636.namprd11.prod.outlook.com (10.172.24.9) X-MS-Office365-Filtering-Correlation-Id: 029f333d-a8af-421b-8d4f-08d4610e7e44 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:BN6PR11MB1636; X-Microsoft-Exchange-Diagnostics: 1;BN6PR11MB1636;3:MKHufui/KBWIIDUluIbgkowyt+Qhxiix5MKBF5VNCum8ZiraOXLCPlCpLLONc3d7TCuIDwtfBkEGGVmLlJSAlkGArHavXdIqMjcsu4dVxKjhkafmGWtAdYiQRFTz16IXJCo4GEu7NszIa8JCdP2vk6bGr3nayPXrQWipSArh8RmgikgyoRsm8ttEzbW6AM1LZuvA8tDiiqolQW9e0H56ER6NpI4YZmwFKrASQjEctjyVKJA1JORJNGirLnezBAK7x16Br9l/EchqTdnngbuh3Q==;25:fXhFwUVbHuAu4iV+jnrz+I6iSdsmA6fGBJEtODAgn4SHM7+k9eMD0PTnnSfn7iB5k2GdZzONLt3MqON6xd37fNXr3YdnRz/izWq/MPg4P7vQS1quGAaRJMQwULpL8tQwxd17gGfMvmpW2qKCf5idC1OBBkwjMaX4L0627sqHYkMp2xetewSNFQf68QZwPknT++gso3oA7Fy6TFnBDXUfX6bJ0ZGqAnLtN0fZ3+o5pNB2MMuV4gznsS/lWx/H93YpOwz9/vQu6iKsg3kae/1+qF3RrLIyQJOJz4jmHqNbYbEFQ7FLJ4cpsyV6nmy+smJGf+N6V01MYWm2x92GTib3JPJY51VU+WWuUFdiu+b1b7YUmGSlVsXEFZc4Bvg3kJ5BIiL0ZRm4JgkhQyagurkxfH4kOKPZUsvhBn/NzU9L2EcRIsDONvZAX7JbZBqmDdm2zjxiBPDIUNon66/XEvrrdQ== X-Microsoft-Exchange-Diagnostics: 1;BN6PR11MB1636;31:BML4b5mOzJVbKrb+O+6F0/xh0Ot5CSC3U1a2PuMz8x/eV7+URo/sXegvNdwNayu/xWS2aimS+yKVOgOVkAA48TM+yI4/GiFDH8ni1ZrD+/O6N1XVeSIf22fKhCN2lkOTH6uoE91PxPD0nyf7g495Mfipqs8cvRgp3biwR7DEUdxJnOfeRYnGceQZh+kVsXKU1AaxUpHwssrR2gkc8Tt5Qjd7VXLTEfqsUbNl2MgpI7xOnqlEmxOQqV3AKzpKezeIQq0IbbwY5OUW5AdvgTwOsw== X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041248)(20161123558025)(20161123555025)(20161123562025)(2016111802025)(20161123560025)(20161123564025)(6043046)(6072148);SRVR:BN6PR11MB1636;BCL:0;PCL:0;RULEID:;SRVR:BN6PR11MB1636; X-Microsoft-Exchange-Diagnostics: 1;BN6PR11MB1636;4:/IHATcAVZ0yTsNU5H+jrL9mQLh+NaH9lZwXHtAqJR7cDTtQIjitCPHuIfTzM74pkVDhKAJ2m0qppWj7mX5/UU74BlEovbLE7x9OlzxbV9lgJXoyt6KX7U2WQlbf9D7X9eUMXoxxJR0ETic1nJck5Vlxs0h0V0+uFvZ/ju6+bPhpk9zAetpVW4bZn1hMIGpxxl0g2e+H6l0ge3OWI+K1eT1j8Z70B+/amhikU6JpYAcsRpKFC6W34/MJz6cpJXynBMgRJ4jpwx/FOwzihWeVi4QpZmrzS65QL/yyeAR/FxKnOgct0PQ4eiYAuUTanWCV+a4BeY3isd3NJoxkWUogekGkndxjOUc5RNFDzhbLpGSj2AidAafDCTN1zBIgzCeCb2EiofVorQT952IAmXMv1+N/KZOKSiIwahek5FOP2ENf9sRrxBfGcRsqS1Cst4NN2StwZQusSN2k33Vi/f/wDggwtdoDpmSVVKnhN1Rv6R6FicS+z0/XXC4abAyG67LyNh+d7U538qHoXEPzkLxSTXw7GP7msMeCGxGq69zYFFHyOK9JeowBy4YyUr7Tq5c+SKjtarqCRIEx8XyGIO0pnHjCB631br2L2qnQdDHXOTAEivluSW+X8sAvFtBNy/d/qfLwgDUPEF6YmY3rX12XC04zyulp2+Lv5KD923pZiE6I= X-Forefront-PRVS: 023495660C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39410400002)(39450400003)(39830400002)(24454002)(377454003)(8676002)(81166006)(65826007)(92566002)(25786008)(6306002)(2950100002)(5660300001)(42186005)(33646002)(7736002)(31686004)(6512007)(6486002)(6506006)(230700001)(64126003)(53386004)(53546006)(38730400002)(966004)(53936002)(6246003)(36756003)(189998001)(23746002)(229853002)(83506001)(2906002)(31696002)(305945005)(65956001)(65806001)(47776003)(50466002)(6116002)(3846002)(50986999)(86362001)(54356999)(76176999)(85282002)(217873001);DIR:OUT;SFP:1101;SCL:1;SRVR:BN6PR11MB1636;H:decina.local;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?Windows-1252?Q?1;BN6PR11MB1636;23:WhefeadYZoxSRxyDpmJxLUQky9OpXG0GveqlC?= =?Windows-1252?Q?EspTMMGPdkz2qbW9yIhAmUDIEC2arqp4Sd7ypnactaSEzF2NDNoGt+0W?= =?Windows-1252?Q?dto3C22fX1sK0JtzxtJDbN6bzMziZZr7qPA2Ik17q8oISndmFxUPGT2p?= =?Windows-1252?Q?lI8jFoeVINGQ/51NrOikbone1Xo0Tf4q6TYKyjB7lA8HyJfLPReg8MUz?= =?Windows-1252?Q?ZuMKtlv/viWHezs+ncsFNAHqIHzOHI5PioJP7PmffgPCDLLPgTylV1YO?= =?Windows-1252?Q?ZCrTVGq1Jux0OCz6KBY/xa8dPeym2zrciQjv3+67Od2Km573fMKOAw6O?= =?Windows-1252?Q?TZMcp67VZY3RfGSqG3oHzUp8sjZH84+PJ4MXHjTGFKBPyza102GDac0I?= =?Windows-1252?Q?4/NFM/uULTQ0RsDDh/7RElFRmy2PAaZ4WBcqJit16hOaUQoPJJj1NTTu?= =?Windows-1252?Q?6BKJLrHB3oB3jCvXNbpMbROQqFKq4SDmPCegM1W2udhfxPPyOy9+wFwQ?= =?Windows-1252?Q?HBpIVE7mJZgOrddpjfr5K1QAqTIT6Ci0RV66Gp1TYIZuWEJeVPEjnE+z?= =?Windows-1252?Q?TWrYqPEshOeTf5p8jG4PnjqahIh5RtnLCDaJgvO7oIs49nnOhPWvT9WX?= =?Windows-1252?Q?apOj0C1ApaSMmIwl7ul/QKMLZaccYFrm7ZMH3udQt5DiFy+ogVmKGVr0?= =?Windows-1252?Q?rwsXjuZFnZNaPuTbbue4BgNzchHwy8xKSPOpekGcaG51LFDS1YCkJyro?= =?Windows-1252?Q?NVFB4ZrGl3UCbcp9LpjN+bGBhDoG9inFTji+92VAUjEPQj6jEKtxWCaU?= =?Windows-1252?Q?15kWchFu0WkindDZt4SW3gqNKS+2IgEQLmu6WUfCquBu2xdPqG1qLuvH?= =?Windows-1252?Q?glKYO5TqLzqsjRECcpn0nBrEaf7iGtsrFdV3gVJcV89vEtQLTr43j2k5?= =?Windows-1252?Q?RW6xyIIc02M6Z7zmrvQVC4L768X9nm5A0aqjE2cmCkVhkvzhf4Rwk205?= =?Windows-1252?Q?sYg6Q26OoJWtXnHgekW+/SG8fwXckg0by5oZxdWFTQJtl8WlBDDE5O8u?= =?Windows-1252?Q?TlCbvs/s9Jz14gO5rYij0bJ+tWlkyhPT2mQpEudScVLcLqPjiV3IeCvw?= =?Windows-1252?Q?gXQ8XEaTA3cRXF6xH1bvSZC86OT2KB6ftUWe9FoVy7bOxkhfNCXoXElL?= =?Windows-1252?Q?4kdjHE0HubmHo4+l6yD3D3KIV5i/11fvh6daX2ZBA6tFtf7JvYJ0xnCD?= =?Windows-1252?Q?lZK4P4Do+20iPDmrG15ZiIS7XuQvVdlxNg/NrzY/EGxylmBHR8NR7dWB?= =?Windows-1252?Q?445ar01hddGViR3mdRTqUB+jg=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1;BN6PR11MB1636;6:W9HMZdtXWe3VFBOqxRzHbnbKmHUdiCRqVBlcqOTfPegvY0Cvhtwwza1fY0bs57YUZWZQC6lEX8jeJMAWg3lIUAcHcs2F6D1D2SX596uY8rPc8NuQauNW6GTQJxqGG4+C7b4jRvY5tBuJsBxyYAJjKokHbXHVeX2olucHtPT2YtOs1X8ZpelG8NF8+As2rpSWlgPKi1x+sPc7No5CEYBF2ENSZ743bh95UtEfOG4pb5yuvgDJ1qvO0SPvmPv1Thfesn9w5Ybd7Go3VkSzqMe6zPOEZAWG8KK48z+MibHTHFE1tlhPwNPwyS9c10RMZ4/VL23BXyFLp7cUX0lCu8Lh8nbruhwyKshfAQ8JWDdsynV9NR6wK3ZU4ewRahAdPNfMphOSsfQCBH//xtXRaWfvVw==;5:fxv2gAHqzLMpztfQ77VlyMqM7iG8osY/nBletrO4DerjJEGQF0tDTGzriknjvDvJRlIOkET3DPwQ8jGGHfTR1n9dKkUyBzhZucAlA1WkrLR247uxAS6QHm28sh9XA3frGv3OlpwpvxZfNcTvMKhprg==;24:VTCvMsltRIUyNx1dKYtHqW4lfiG+gC2SLsnc2L39TZGaAg5yB9sTH8b7mSeL9Lk9SqQFI+VVm+RItrXcRi1+YTQk6/mOMlZsV7aa1uS7N4g= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;BN6PR11MB1636;7:4YjRlflINFXY/cw8cUsdiXxpxOFVDj//+dfJxFLz5ElAdsHJNA2yBpREU8UOPP6GBV96vyfTqe4cZS3kxhTBA1UTfz0nNe14UTGgHmZiokpqnq7LGSS8nrHgkAO73nPn4geE0qOrhJ3iS/9sZxIGrBVXT1xM3fE4ZtaOvx1R5s1TGyNJJ/CAFmFtNjEbzjtmIc1obdnIx86gllviohkFHoh4ArsN6/9sZkC+GZ0ucH6WLIX+B4kMPFe0m+5RQCjh3xW5V5I8gGqzidFlpKK0tBDEoAJgyXeNsRf8KQAHCXJGAetYS6ul6V/aXoEjG3I1mI5xMeXC7UhyCHFE/a7wfQ== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Mar 2017 01:50:23.3034 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN6PR11MB1636 X-Pg-Spam-Score: -0.5 (/) 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 2/28/17 11:21 AM, Andreas Karlsson wrote: > The only downside I can see to this approach is that we no logner will > able to reindex catalog tables concurrently, but in return it should be > easier to confirm that this approach can be made work. Another downside is any stored regclass fields will become invalid. Admittedly that's a pretty unusual use case, but it'd be nice if there was at least a way to let users fix things during the rename phase (perhaps via an event trigger). -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers