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 1lUcmw-0007Cw-Lp for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Apr 2021 22:06: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 1lUcmv-0002n1-9u for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Apr 2021 22:06:09 +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 1lUcmv-0002kO-2s for pgsql-hackers@lists.postgresql.org; Thu, 08 Apr 2021 22:06:09 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUcmo-0000u2-TY for pgsql-hackers@lists.postgresql.org; Thu, 08 Apr 2021 22:06:08 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 138M5sN01933676; Thu, 8 Apr 2021 18:05:54 -0400 From: Tom Lane To: Justin Pryzby cc: Alvaro Herrera , yuzuko , Tomas Vondra , David Steele , Kyotaro Horiguchi , Daniel Gustafsson , Amit Langote , Masahiko Sawada , Laurenz Albe , pgsql-hackers@lists.postgresql.org, Greg Stark Subject: Re: Autovacuum on partitioned table (autoanalyze) In-reply-to: <20210408220042.GM6592@telsasoft.com> References: <20210408213051.GL6592@telsasoft.com> <20210408215625.GA17048@alvherre.pgsql> <20210408220042.GM6592@telsasoft.com> Comments: In-reply-to Justin Pryzby message dated "Thu, 08 Apr 2021 17:00:42 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1933674.1617919554.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 08 Apr 2021 18:05:54 -0400 Message-ID: <1933675.1617919554@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Justin Pryzby writes: > On Thu, Apr 08, 2021 at 05:56:25PM -0400, Alvaro Herrera wrote: >> This new bit reads weird: >> = >> + Most parameters are not supported on partitioned tables, with exce= ptions >> + noted below; you may specify them for individual leaf partitions. > "Except where noted, these parameters are not supported on partitioned > tables." I think what it's trying to get at is "Except where noted, these parameters are not supported on partitioned tables. However, you can specify them on individual leaf partitions." regards, tom lane