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.96) (envelope-from ) id 1w9Vx9-001Uw4-1V for pgsql-hackers@arkaria.postgresql.org; Sun, 05 Apr 2026 22:28:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9Vx7-005DGS-2B for pgsql-hackers@arkaria.postgresql.org; Sun, 05 Apr 2026 22:28:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9Vx7-005DGK-0o for pgsql-hackers@lists.postgresql.org; Sun, 05 Apr 2026 22:28:21 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9Vx5-00000000kne-2ELq for pgsql-hackers@postgresql.org; Sun, 05 Apr 2026 22:28:20 +0000 Received: by mail-ed1-x534.google.com with SMTP id 4fb4d7f45d1cf-66eab157fabso1068291a12.0 for ; Sun, 05 Apr 2026 15:28:19 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775428098; cv=none; d=google.com; s=arc-20240605; b=DaMHQpH+16T9kVLqluOa8EiJKt6fNpc4ltjqbbzsDo2qDtjxghEY+zl7xJLpM/0qm7 +orHE6PV8rp5cOWaWZNKuhKrpn28ZhihT8I8qpFpKawuvtebEBYQcfmmHpUgBiAnVHQr Ggsy10wQvLYJnAeo/0zvnSrNL547QnxdjwKwW8KQXAHOjqd1jjdu0x6O/6yp6nzX4lvS r62ovog2kxTz/IbUOR3yI5mZTWJdjfSzzaIEPVcu+TPxIfD9wDA1zcVoGtAC6vKbJ5I6 80y0r7sXzdbt70ZyJNUvnclM6lJGEnGq/DxWrl60jpnQB+1xYdblqvU6TdseNbQeA4E6 YZYQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=CLZEEO05fHJcUFOM/15Owu/ZC5qtI2d8x/xiS7zDR88=; fh=dv77PeBH+XauWJmVgxAHIkYzvNUpSnHY6uj1sDPSImw=; b=NT7ASNTxt2MdFFLDxxWNWvADxGH3ouvxO2m44lusixwVLM2s0jHCUPgSBB0Paw3syT wux7KF259GmRl5sxMa5mq6rwhwBusDC2OYx9NGPeJHCytbimHXlvJCACtchPAob/pKP4 3t6IefEZaCRht5gBpqNtS4pooo4d14PmUwN4r2SMrjVbiUE7zJmCe5QQVDTHJtZmZ87H c2B+6HqXaQ53jTjzBKulQakwRFJcrc9SykXFiIq5wOzwMbjdJDUqu92PfkzzSFSkmeIX LQ4V/hl+9cJgrgmFbkGab7L4huR2iquzubw7LAfa9HT0rzu15+Zul+WUm/SrIAj33P2U QiMA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775428098; x=1776032898; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=CLZEEO05fHJcUFOM/15Owu/ZC5qtI2d8x/xiS7zDR88=; b=sLFyZ8B1GF+DJy+aWUpCcqTi5j+fGvGyadvm4WGj1/jvzArDxrgo9ysjXBZ+escU7a 2BqFICQw0jeQ0b0c4HDj2vW+aqofhDycIlrb7PNKmu5Ztre6+dJe73J7qPf94hHrSMVS ACjp6B47M0ChJ4kgI//x4iF8HgMB+e2VpYYHP+LKXLxbMPjKFO1bkkhUPFQP7E/NuCOS 0qk7SQ5rf7ZfuUtlWYK7cdPKCyqz3krnlga0T8hPDcRt/Wr6v0IxUZULpeNhKagEYzit rG26uRntrZ1t1eoKky9bYa2XAm9FazQo9C4gAxv1Dm+SG7kWqmPb1R3XlvD5/YK1Q23F Ml7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775428098; x=1776032898; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=CLZEEO05fHJcUFOM/15Owu/ZC5qtI2d8x/xiS7zDR88=; b=XTlGrICo7z+w9W6tlxuwhTFtebBrPYyfXbBdLCRTOslna3jvtO6nfAWbVXAT5G/qvn GCLIK/hIjL00FCX9rqvaXI7cczANKU2ItR359CG3Z8eCbIEvZ4QfWIWU+mwGqtQic2Tf sP14vnRdFElodRltwtD1FroKQxf1f+B+GMCc3cU6mk51dylZFJR0p3Ht6rCprUlBub1r xir7V2CNVHgK8tkpuYm8fzSgU/w8dXU4hd41HrnU7xZStI0Nr0fSmize5u2dQSKp2i/T WC/pbmIdClvH1sr7HKONpbwALaD56MfXMuIaeieviSKLa5+fgJZWhDOeeqm4EYgN8I2n i1TQ== X-Forwarded-Encrypted: i=1; AJvYcCUi4JpNr/olnkEXpHEc+PkQUtHoo3ipe4EnTJ+KZ/9T0X453TLr7oJG2Cvv3UfGRyaU9B+3OakJjrqWg/Tt@postgresql.org X-Gm-Message-State: AOJu0YzEGki0Fevin0j3jkiNCHuWhsNlCKBFNFXHxkKLkKC790S8iHF4 9NEB3y488wYmqrEBXt4mgld9ClzOkvYAd8RoHK8bgvCqXC7PcnQNYBBzevTggT3pvHoDdsS7Caq 8gvItIQog2KbDKtdxO2/55lCsC9BFUEI= X-Gm-Gg: AeBDiettHjLZEjUhl2w5QZYEEBx0ZiwId67an7YXupPuJeiuCW/hKN8mLRFwQzzoehJ khqrxPmPblAH08oPubBRSkiq+VJ/zWPfBmVAmmCh4ZmrmZjY0f/H/dDHtBjdqJv3UMt91aeqIK/ spct67lmc7ia649HRTG46Hc1X8ifL2whe7YokRS+n/a1Z2hx2GdlexjI8ea8soCr1Yzewordal7 8Abdclb5TfsukQz27QWKgy6neUXuAZ+ujcAKYMX0Mk665msVgY9ms+t86si+IN4VIUWgHFnSeWn /gFfD60= X-Received: by 2002:a05:6402:3589:b0:66e:6f3c:894e with SMTP id 4fb4d7f45d1cf-66e6f3c8cefmr3206861a12.7.1775428097946; Sun, 05 Apr 2026 15:28:17 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sami Imseih Date: Sun, 5 Apr 2026 17:28:06 -0500 X-Gm-Features: AQROBzDocGhMo6pA4TpwT-iZ7wF2SBltt0MzN8mBDp2KQCS-Ys7bLCCrAlb2ATE Message-ID: Subject: Re: remove autoanalyze corner case To: Shinya Kato Cc: Nathan Bossart , Bharath Rupireddy , Robert Treat , satyanarlapuram@gmail.com, pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > Well, autoanalyze only runs in this case if autovacuum is disabled via the > > table's autovacuum_enabled reloption and _not_ disabled via the autovacuum > > or track_counts GUCs. I think this is pretty clearly unintentional, as I > > can find no mention in the code, archives, or docs. And unless I'm missing > > something, it's completely unnecessary. So IMHO we should just remove it. > > +1. I think it might be better to mention this in the documentation to > make the behavior explicit. What do you think about stating that an > anti-wraparound autovacuum does not perform an ANALYZE, like in the > attached patch? +1 to the additional documentation. a small nit: We can just say "skipped" and not "still skipped". -- Sami