Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kGtAE-0006Ct-DY for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Sep 2020 00:13:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kGtAB-0005GN-9W for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Sep 2020 00:13:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kGtAA-0005GG-Vh for pgsql-hackers@lists.postgresql.org; Sat, 12 Sep 2020 00:13:07 +0000 Received: from mail-io1-xd42.google.com ([2607:f8b0:4864:20::d42]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kGtA8-0000YB-1x for pgsql-hackers@lists.postgresql.org; Sat, 12 Sep 2020 00:13:05 +0000 Received: by mail-io1-xd42.google.com with SMTP id y13so12920150iow.4 for ; Fri, 11 Sep 2020 17:13:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=PXpXpO9IwYsTg9vpAMjf7v2Ipi9TU0wuvE4gHy7wqoA=; b=Jwvcodw3p63eDf5P+izWiWmHMLc2QSA0Lil1Se940EfcCk+MYZRW3lnmBeLUVT6YUU S5k3D115SqCX6WePhqMCxRUxu/5yqy+tLhOnpiwUP3thHIzn6wzdDJmsYYF4CNECZ9DN H9NpSJ6diUbi0CCrI/RXD41kX6kefpK3oZD0XM/STlLOOi4nNQz50Kle2d7/X76QWpiu y+5PB607FKtZ/BOnegoyHmjRdB/k4fFetIrGBj5hhewf898nR8t0i4ywSsOcbz+H4J1F /y9T+aBFNIsYfKTGPVBtGum/deabaYa/vNx7boUeO9qbzNKq0KDjiCCyw2OulhnAMW0H EmdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=PXpXpO9IwYsTg9vpAMjf7v2Ipi9TU0wuvE4gHy7wqoA=; b=OTPxFA9zod+evR10dnR2jcEYLdjWtemYxA6RsjqCVGVG+GH93D+fvBCZsS05ljYrVM p4q+mzwns0gONf3/70ItGLG9fuITsRl2WI+055pOFNFJZn9IISQd8n1+MKjLQnPOIklO BOf+EvLcYYB7knp/1rdkPUykafpxUP70cmQTI8ceG/UxAB8VqQuJ15asgGyuDwlxXqMM 3YFtb67ah23QDfwGlaplzMlSDCWdITYXYoCf0gSe9PVjUTAGHTZk2i2k0pX+c94PFs2D GNEtN4zrJeEYh1h3YhzWzTiIaYEUX67T8mAuzLQEqD2k2zjSMLsItkbkdAic9XS8YsvC 9asQ== X-Gm-Message-State: AOAM530uYBij7X30yjo1uZkJ1+MG4ZH/QZ55fUSWaTzAVaYSeyKqRSZE aaKJVwB5x2clS+iKW8AhS1ZOiA== X-Google-Smtp-Source: ABdhPJwMOHamgjW0rS/taLhsat+SBgQhlotRx53iw2VLFqLPGa7sR1kBosg46919IB0PRQEGkxPV/w== X-Received: by 2002:a6b:e206:: with SMTP id z6mr3816452ioc.208.1599869583200; Fri, 11 Sep 2020 17:13:03 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id k82sm572006ilg.77.2020.09.11.17.13.02 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 11 Sep 2020 17:13:02 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 888C280070E; Fri, 11 Sep 2020 19:13:01 -0500 (CDT) Date: Fri, 11 Sep 2020 19:13:01 -0500 From: Justin Pryzby To: Michael Paquier Cc: =?utf-8?B?5p2O5p2wKOaFjui/vSk=?= , pgsql-hackers , =?utf-8?B?5pu+5paH5peMKOS5ieS7jik=?= , Alvaro Herrera Subject: Re: =?utf-8?B?5Zue5aSN77yaaG8=?= =?utf-8?Q?w?= to create index concurrently on partitioned table Message-ID: <20200912001301.GQ18552@telsasoft.com> References: <20200618024114.GF118592@paquier.xyz> <20200616010221.GA2353@paquier.xyz> <20200615123742.GL52676@paquier.xyz> <20200808063744.GG20473@telsasoft.com> <20200809050009.GA17986@paquier.xyz> <20200809234423.GH20473@telsasoft.com> <20200901055158.GH3511@paquier.xyz> <20200908023915.GD7158@telsasoft.com> <20200908043105.GE19261@paquier.xyz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200908043105.GE19261@paquier.xyz> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Sep 08, 2020 at 01:31:05PM +0900, Michael Paquier wrote: > - CIC on partitioned relations. (Should we also care about DROP INDEX > CONCURRENTLY as well?) Do you have any idea what you think that should look like for DROP INDEX CONCURRENTLY ? -- Justin