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 1p2dlh-0005VE-Pc for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Dec 2022 19:38:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p2dlg-0003El-Mn for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Dec 2022 19:38:16 +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 1p2dlg-0003Ec-DW for pgsql-hackers@lists.postgresql.org; Tue, 06 Dec 2022 19:38:16 +0000 Received: from mail-pg1-x533.google.com ([2607:f8b0:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p2dld-0003rj-T0 for pgsql-hackers@postgresql.org; Tue, 06 Dec 2022 19:38:16 +0000 Received: by mail-pg1-x533.google.com with SMTP id f9so14276504pgf.7 for ; Tue, 06 Dec 2022 11:38:13 -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=iLwmPLRiNqxoNGE05TjxEUm7mXsxcQehSsie1koQinQ=; b=qHhTchY8WjwsZc2icTcugU8FSHhlAKyVSkY/uPZof2sX4wOjZNs1rKXy+zuEW/2mf7 HYO9hRKVQuv47Rg8wQhTRZyMTlLm1vB2JgYysIcpWE22IJWku9HfOMuJDP9wqsWqQjMn 32Ci3j+WgZKlgtoaQjCU5rCFe73cRECxaZ1/o9Bypfo2GvaSvranDzmIgVfeteMQChib 5UsOLSoNnxOwGDNl9K5FO5TSyX+sLGsN4qjm/SmJNpUPCzW/SJDuy/g3+OW3LfXMdhJz 5uLIFTNvQ+ygicFLAaXMK88IIEf8siHBGD+7OsRS7MHjzLeErVE4czQwZ7HL96IeaSSc xjFw== 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=iLwmPLRiNqxoNGE05TjxEUm7mXsxcQehSsie1koQinQ=; b=q2k7Uj+JXjoAPV+4EKoou65ZpQ4UoupRoEhbsta9lbZB9WQoNR8wqRu8yHyF6tW4m6 hxe1XhjOtUzdi7tbqwMbhDZgiPCkLl5b1YYbYyd5k5SGtWv26YTpq8TBokbru35wNxAe GNewJohp0lrTbX/X0f9Vtl31i84UsyzRAD8Gxj+yXw7zm1+xgdVkLlDDORKVrFFY6wHC /W5AdArAB5BEgN4d+iaM8fJ+VZ7BhLU9moAszh3R5iCkSPSIUZQAECaWI9M5vluYFN3q plc9vw7bIYJg7lfqst6+P1tug1FcMSTtq/yi7MZ5zsuPR+LXzoQMTQwd1MejVkBc1P1+ 1j2A== X-Gm-Message-State: ANoB5pktZyFztI5LP/G6igdbeNKMszuGD2kFh6iUlXSm5fv6uvl7OaDO xTTeu+hTIadfcQaFgHyDGOk= X-Google-Smtp-Source: AA0mqf52sNJAMglJWXu5MmNEfPCRRObT0FvlDSf9YSI5VIbXMofIWBT2/95SOSMtAzawTVlQI3PckA== X-Received: by 2002:a65:5a88:0:b0:477:78d0:edb1 with SMTP id c8-20020a655a88000000b0047778d0edb1mr62391107pgt.587.1670355491819; Tue, 06 Dec 2022 11:38:11 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id d75-20020a621d4e000000b005622f99579esm6012699pfd.160.2022.12.06.11.38.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 06 Dec 2022 11:38:11 -0800 (PST) Date: Tue, 6 Dec 2022 11:38:09 -0800 From: Nathan Bossart To: Pavel Luzanov Cc: Andrew Dunstan , Corey Huinker , Tom Lane , Stephen Frost , Bharath Rupireddy , "David G. Johnston" , Kyotaro Horiguchi , Michael Paquier , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: predefined role(s) for VACUUM and ANALYZE Message-ID: <20221206193809.GC3078082@nathanxps13> References: <20221117043952.GA116054@nathanxps13> <20221118170504.GA401589@nathanxps13> <20221119185004.GA539143@nathanxps13> <20221120165713.GA597801@nathanxps13> <0b00a6ff-1475-c0ba-15ec-5b5e381c6359@dunslane.net> <20221123235444.GA479104@nathanxps13> <8609e4f7-5ffd-9fef-a5e0-78edb8818f3c@dunslane.net> <20221206000414.GA2813564@nathanxps13> <6fff4349-bbcc-762e-0e81-938ed58e486c@postgrespro.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6fff4349-bbcc-762e-0e81-938ed58e486c@postgrespro.ru> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Dec 06, 2022 at 04:57:37PM +0300, Pavel Luzanov wrote: > On 06.12.2022 03:04, Nathan Bossart wrote: >> I wonder why \dpS wasn't added. I wrote up a patch to add it and the >> corresponding documentation that other meta-commands already have. > > Yes, \dpS command and clarification in the documentation is exactly what is > needed. I created a new thread for this: https://postgr.es/m/20221206193606.GB3078082%40nathanxps13 -- Nathan Bossart Amazon Web Services: https://aws.amazon.com