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 1p6393-0000HX-HR for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Dec 2022 05:20:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p6391-0001oh-8Q for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Dec 2022 05:20:27 +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 1p6390-0001oX-Pm for pgsql-hackers@lists.postgresql.org; Fri, 16 Dec 2022 05:20:26 +0000 Received: from mail-pj1-x1034.google.com ([2607:f8b0:4864:20::1034]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p638y-0000P8-GN for pgsql-hackers@postgresql.org; Fri, 16 Dec 2022 05:20:25 +0000 Received: by mail-pj1-x1034.google.com with SMTP id u15-20020a17090a3fcf00b002191825cf02so1328354pjm.2 for ; Thu, 15 Dec 2022 21:20:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Y34unmNHZIG6VUP7vdQYilv7o/OAT5sW06Ep5tzuEq8=; b=Unqwel6rZ5KgIRckIms3q+7XrNN+zivlutqaaWp6s7Ni5qDmoIEpvhF8V2e/7XeDMn AjC20d5YABQPwhYtUupur2yJ60l/t13bertpTJ1iQOC4Kcj6VoobF45N0VOx7zNrwSvj hvNnw64KOs0XA3H9xhMeJs2Et5n88QqRB9BPfs6P9c3iy2icFvYiifdb5X2fsOMtnhfT 5Vjyja34VpQljcrkpfjisJ81bMIbYkCgFvHYyseKIwSMt6n7Z0Kb+l8cw+bbVwwQEpmf 9lXQSG8G26I+p3OfAlKhqFDpyRhGg+cgFxSt3312KlP60Z5H+wJMNQXJ322dQTn0R8It 2XQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Y34unmNHZIG6VUP7vdQYilv7o/OAT5sW06Ep5tzuEq8=; b=Q53obu/LFyzj3KsAnWFz9a3F028Zqk8Uxu18IQmhgyKqLP8bt3p0Aen0NuDX0Gj10r qXuVfInyIqEOg7aypjBMSHz31IKdM9uPgYcoVQsB6Ya6hCfzXZ0enKm4W8mdOi+waxSc a0NNB3457r/Xy+iy6XWsv0Zgz2CYjZB5Qul+Ml0Fy5XINyW9Gaz+S8OF/n0lDSi1Qe31 YPRJFS66eDS6KBEcDOGT6dO1Qte2YUzdxNUwzr2WvpTAB//n5O/rp0poAnzYCOpIbrCo VZlNg2yt/gcuO+UMrplgjEUgg7DBl+Mwv+oS6K1ip2plcmecv6mIVi5JIFLDb+GeCauN /YCg== X-Gm-Message-State: ANoB5pk28p6KWoXgg1oTIUL3b3bzJJhA/v1XPLVvySon45wKRfBBdzLC AKLfUhqwqcxUUaxNj7yW89I= X-Google-Smtp-Source: AA0mqf54nQLReKXTBkyD0fz8QTHGsn4k3rtDCDgBYBGoT9feyrT+JMiH7bBQD41zH5St8nFnd74N1A== X-Received: by 2002:a17:902:8bca:b0:188:b084:7bef with SMTP id r10-20020a1709028bca00b00188b0847befmr29865288plo.42.1671168023588; Thu, 15 Dec 2022 21:20:23 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id b2-20020a1709027e0200b00189240585a7sm558516plm.173.2022.12.15.21.20.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 15 Dec 2022 21:20:22 -0800 (PST) Date: Thu, 15 Dec 2022 21:20:21 -0800 From: Nathan Bossart To: Jeff Davis Cc: Justin Pryzby , Pavel Luzanov , pgsql-hackers@postgresql.org Subject: Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Message-ID: <20221216052021.GC804311@nathanxps13> References: <8f7172da-2b58-3bd0-97ae-5126e2a7970c@postgrespro.ru> <20221214221140.GA1153@telsasoft.com> <295e86c7aeafb8e2623f8eccdc846855bf2c7e0c.camel@j-davis.com> <20221215194813.GK1153@telsasoft.com> <20221216011926.GA771496@nathanxps13> <71a13aa425ce9f27f6cf7396a59983190d511b76.camel@j-davis.com> <20221216051354.GB804311@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20221216051354.GB804311@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Dec 15, 2022 at 09:13:54PM -0800, Nathan Bossart wrote: > I do wonder whether this is something we really need to be concerned about. > In the worst case, you might be able to VACUUM a table with a concurrent > owner change. I suppose we might want to avoid running the index functions as the new owner. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com