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 1p38NN-0001S9-MR for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Dec 2022 04:19:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p38NM-0000Ir-9H for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Dec 2022 04:19:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p38NL-0000Ig-Tq for pgsql-hackers@lists.postgresql.org; Thu, 08 Dec 2022 04:19:12 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p38NF-0004tM-D5 for pgsql-hackers@postgresql.org; Thu, 08 Dec 2022 04:19:11 +0000 Received: by mail-pj1-x1033.google.com with SMTP id u5so472566pjy.5 for ; Wed, 07 Dec 2022 20:19:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=6OwzVO4xQUqVDi/o7a0DtJgw0/bXnZvbMrXmfbex9UM=; b=bMJYRjGqurkl1XXin0kj6pFFvDj57iq3MV1SXKNaEhYJF9iwe+NPnjWNV4fAipIaxG IixxdxGEq+xH2Ho1OP4ZpCFArSwPOmbFpHTjt8no1Q5zKNuPeOeAWhR4Ue8QNaPDr+rq 6f4PXaNiFgovmcLU2Y/UATxsW62PW3ziDw2QzT2Msl+nt+txEkC1rs8lOlAxsEcaQ9Pg Zp5G4WNqzfw8mHkIcS5qUdb+8amuQMbxbGQMIgz8wxxTj55xHp8E6JXKm29Ggjftul07 f8EceDIZmQGh09Ds/LCUk0yUeu8ymr+ph151uE46LJLguU1owE9xU+04bL4HfAWl+/Y0 Vt3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-transfer-encoding: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=6OwzVO4xQUqVDi/o7a0DtJgw0/bXnZvbMrXmfbex9UM=; b=GjDDdIGxsQnRY6zlF0UMvxqck8E+PZ4KhtA+by+TLl4Iu7dryAxGNR+Es23V64tQS5 pgOXAR63zIO0oBgtJg9Njpf1EJCvFBeKnWV3avDCTq/sSBzt2nVhiZdvwTD9pZ/olHxS dYPFm7zw2Hl73iiqj2knpXClitoxhpUHmtHC+6mxlK5eg2p/4+9hE81P6QvSuBfrVezl 8JKCDbOIdMJZrLTtE3vtHMgq9BafipGjDqpQwJx7Dm66ukx3wfGurtjfqZf5AO6qKOL3 b57IOGB1VLhN4RLwNs8hwhPA9TdxetFs9K+FYzdm8RitXXztEb6nSMM5lzKGlNP9iq4c BODQ== X-Gm-Message-State: ANoB5pnthXB3u85bWzOSIo7UZOPV3/mQmGXyKsv2REsrU358o5g8ocUB tLiXGa1yb7Dz8Znxo4dMDWONGgWc53k= X-Google-Smtp-Source: AA0mqf78xnSFtU0eLF7+h57tCrtq5FZJ7OfhKPhUyhZgo9E721aFE0PcZAGVgaR9UTHB3ROxIkuKwg== X-Received: by 2002:a17:902:d652:b0:189:a770:6eab with SMTP id y18-20020a170902d65200b00189a7706eabmr39451289plh.135.1670473143056; Wed, 07 Dec 2022 20:19:03 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id o13-20020a170902d4cd00b0017f7c4e260fsm15521248plg.150.2022.12.07.20.19.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 07 Dec 2022 20:19:02 -0800 (PST) Date: Wed, 7 Dec 2022 20:19:00 -0800 From: Nathan Bossart To: Justin Pryzby Cc: Pavel Luzanov , pgsql-hackers@postgresql.org Subject: Re: add \dpS to psql Message-ID: <20221208041900.GB216874@nathanxps13> References: <20221206193606.GB3078082@nathanxps13> <661148f4-c7f1-dec1-2bc8-29f3bd58e242@postgrespro.ru> <20221208023929.GB27893@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20221208023929.GB27893@telsasoft.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Dec 07, 2022 at 08:39:30PM -0600, Justin Pryzby wrote: > I think if vacuum privilege allows vacuum full, then it ought to also > allow cluster. But I suggest that it'd be even better if it doesn't > allow either, and there was a separate privilege for those. > > Disclaimer: I have not been following these threads. I haven't formed an opinion on whether VACUUM FULL should get its own bit, but FWIW І just finished writing the first draft of a patch set to add bits for CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX. I plan to post that tomorrow. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com