Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1unpkA-00BgP8-Uw for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Aug 2025 02:37:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1unpk8-00CSRb-B9 for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Aug 2025 02:37:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1unpk8-00CSRS-21 for pgsql-hackers@lists.postgresql.org; Mon, 18 Aug 2025 02:37:04 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1unpk6-000R3L-1f for pgsql-hackers@lists.postgresql.org; Mon, 18 Aug 2025 02:37:04 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-3e57376f655so30670975ab.0 for ; Sun, 17 Aug 2025 19:37:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755484620; x=1756089420; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=LJKPLSVM+yhmclqiOwIjkoVT2ylAHXq3BcOKLkbFfgg=; b=hWcD+3xVj7dT5xrrhP9xo6SsOCsApjbMiTlK0iNZgaXq+KNKZT32mru/DOQk/ao9GH Av8V0Cl25NsTiZyqjzox2Ye6HJt4xd8xOxbGxtob9LRJZ9Quv63fOgcHNRPaFbtjLrRu zDoAUcAurvv9Wx2yXL3Voq+vcGAEjOB1EzxwbbK5QFCn09OK1f5J5iR5QnznjhuIJihc qa3xBFgQorg6GvE/VSBRw7UzUp99XdodwgnuywozaQIwrFHaEyhagv5m81OmbCY4M9ap ft72Q+WZtdaeizU6cHXVSVK5nTtn6Yp6cgWkPxTBCxANhhE4rylCyDl630Vn8ZrK+Tpm kUuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755484620; x=1756089420; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=LJKPLSVM+yhmclqiOwIjkoVT2ylAHXq3BcOKLkbFfgg=; b=i33xI+7qxRHuB20Wn1ZWwi47VzWaV9o6U7zIdxKU4NHZy4+bieugfzf9aVXl+nHteN GLCZ23/Of7A7u4BUCSuN9Ofoiq2vgszfm/OFm2hIIza2Bcpebb9kkqjaNwUI6SONC/Ho GNRj/Bl5bdttnR7C3XpzVNCnJhm0O8TVvzqf9rUoycA4BwiF0kpIin1yINmwIoY4ZmXY iJL89bLjFoyl2yf5/5cbgHYceeAxJnTVdxDO6zcdE8KEzUmDxJAn/Btyl7EI/c/bBF72 izvR9Q39200x2uSKShnZLM/EdA/5SlXqgPV49s+pPazz2xQF+EWy4Mbe66oXYaVKORDS 2ygg== X-Forwarded-Encrypted: i=1; AJvYcCXnjuUeCODksbxxCZjh5vwjUhY6BU2Azpv+xN5YX39t27xAYrq7bSgYvTyQ5zgIfiM4qew/9vRN/NhwLf9H@lists.postgresql.org X-Gm-Message-State: AOJu0YyFbPH5cYMvIDz6pcegtnAwqC6yMe0CfHS4/Nf2lZ/iy/Q16lLh JZTfXkY35BL+mt+W2Uts3Ws/5iSJyPAXCN5MroYV1kGM9xf0zHD66823fFnQcVnbZvDyIvz5YGv bdpr2CCvAs79P1kZJSmhL5lgYDoFG7o0= X-Gm-Gg: ASbGncvOcuwQIwkteIPP3NjA5FQXq6M1o2HxkYNkE6pcJ4kRjJNwXxjRCbqmSG1hJRe L1VsfBLYNTaaMupNsTDYxcmF3ggpWkMC/UrVgchqPlLnyKrbiE4+LqlHLc/2Wv5zqDy1NTc7M0W NPIfRnfRe7P9XBsrtOeVLjwhzvTGBJ6T4iyZkEXNhGZKO77DjodzzQOrOL+X5+Obcm4K8OTfLjF TfNFeoMWBWsxWZDsfE+WH4/s3jibyecK6Fdrg== X-Google-Smtp-Source: AGHT+IFzD7MImdS94wNM31hG+3i2nwYGdJDfid8/S+ySovV3giZ+egIarT/HtoYx8z9lPsLVmIXjVqtwn72R6E/Tb/o= X-Received: by 2002:a05:6e02:4408:20b0:3e6:6add:d0aa with SMTP id e9e14a558f8ab-3e66addd433mr24679505ab.0.1755484620249; Sun, 17 Aug 2025 19:37:00 -0700 (PDT) MIME-Version: 1.0 References: <08d943a83590308cbb9be594d80b4e19ca80e08e.camel@cybertec.at> <2505eef1-b6aa-4518-baff-861a2e6a507b@gmail.com> <2c1f1834107045dfa8b32417771b56bab0cffc56.camel@cybertec.at> <2cce9851-327a-4b1a-ab8e-531c2f92532b@gmail.com> <9c9cb744-b8c7-4d75-acad-595b3faba187@gmail.com> In-Reply-To: From: Fujii Masao Date: Mon, 18 Aug 2025 11:36:48 +0900 X-Gm-Features: Ac12FXzZ_xFT9na0-YuVwiwDsBbPPxmE3GhQkC95eumuKBHVLoV0cDBaew_fvbQ Message-ID: Subject: Re: analyze-in-stages post upgrade questions To: Nathan Bossart Cc: Mircea Cadariu , Laurenz Albe , "Zechman, Derek S" , Adrian Klaver , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Aug 7, 2025 at 3:14=E2=80=AFAM Nathan Bossart wrote: > I also am leaning towards treating this as v19 material. It's a nontrivi= al > behavior change, and this option is useful for major version upgrades, > which is an area that we really don't want to surprise users too much. +1 > Furthermore, auto-analyze doesn't process partitioned tables, either, so > this introduces a bit of divergence. (I'd love to see that project picke= d > up again someday. Perhaps I will take a gander...) Sounds good! Regards, --=20 Fujii Masao