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 1w9Zlb-001YQd-2b for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 02:32:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9Zla-005xRp-0l for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 02:32:42 +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.96) (envelope-from ) id 1w9ZlZ-005xRg-2y for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 02:32:42 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9ZlY-00000000pUS-0Krr for pgsql-hackers@postgresql.org; Mon, 06 Apr 2026 02:32:42 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-89cd8596724so42313746d6.0 for ; Sun, 05 Apr 2026 19:32:40 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775442759; cv=none; d=google.com; s=arc-20240605; b=XLpYzz9uvTrN2RQNhW2SU2dYxKOUctgaCN3akBZNO+Md4FX7cAd//AOqpveAYVuh8V DbYfck7C2qdmvsWGItXrCVCxK72d2ozBK5YqSTxX53wwu7cra057rs8vbTxXm0jOfktC tBS9lXVzt7LeowAnoJwhe+pWxdoSrPVyC+BcvgoNc51R7tHj5Xtw6abTFD0ahXyznT1A +K6YMiTObwa/HE0AMGqxyIHRB40CfbR8bZhUcKSRlB0rmIWXXY2Lnbbd/2BDCOuBrjW+ bvrpqhP0XfXYf+6I6gJRUwImxYTthpfvJO8nsv6PF4IHXMTizWpB3/o4K9rgHmE7LQsv qqPg== 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=xg1zGEIz6xI1CRicVqcKuHfzXmHW8N2Q8eaKzw9bLlA=; fh=c8jeq6uKbPBmIwEluhkHgFN34XE67mog0bfoCueyG5w=; b=jBbii1Xuft1SnJehRJglg2XJCpI8DtMOu7e0ZwnI1E/n9CPINWaFsJ9wiAYrIkqTtB r3dCkVleMNYjXm9dKaVJmHNM1q1lze4bULxUO+f1uydX+YJsMcCDmj6CWCDhXX4lV+ek uWwm3PDgzpuNkmC3q6GTarDP9hKKfUTbdGkw8OK9KV43jEIiN8lJGSXzsoQEkAeSJ4ob 4M/QUx05xgYqGryjVDVpNZJzpHEFErFqLVwL/kj0xsV2+PL2kqCpWwkOovWyw9eo6JnY 5X0nbsiPjKJIvVH/5MJKViXyTrxCziuXLnbmsZuMl3bZpa/aGSj9Q55r0PMPaMkA0H/l mRNg==; 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=1775442759; x=1776047559; 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=xg1zGEIz6xI1CRicVqcKuHfzXmHW8N2Q8eaKzw9bLlA=; b=IN7adVQtRSb5cIVxm+TKBV25gau73ng/8NGsfNh0hDir0UgIHfAXMhej4hm8pbzOKU yXAuEe6gqELmHyexPl9u0n+ADXZddJhOfMXEmN0SuVutv/seHip7ZX10nLOk/WxGFa1n V7cg1+g16O62FhGqHfSLfWe5MkY9HIxiLsUomsv8tlzky5sreKwgT1Bvf7VIGj6itqme mxoGErbNGFGsj1KQWmGgg5zHc3dCdC8VtyW6OuUQi4eglPWbhhkq7TP6sIp3THKuDbu0 6W4QcD0Y4EHqQxKmbnnA4DqW8WwXy9EwY/QVgu05R8BdOwrUxdhrke4Yhnx6ayZib5nN VHiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775442759; x=1776047559; 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=xg1zGEIz6xI1CRicVqcKuHfzXmHW8N2Q8eaKzw9bLlA=; b=nn4BhPNTTiM3iJkCDVX7vSHCuYj/8bD56pCNnJH+Q69z0etBC2LEGPqjRdJMF7Lidt BKP58kKForqfILMIdDZvmrum66+TiJk1iHimy31OPhyrKmgDn4pAinWtrqGMjbb9lWgP MpbzACxKpPY+LQHJvKKQ0RjVkAW4YKZrDURu3eNfAeQpGZhFbnh0ibk6T/Ts0fLn7v98 DwmXw80z3WlwSsn17V4PeBJ0FoHacYSwKwOS/pMliVPgQLuOz09c3C5HwxpBeXBvnVZQ PKuhdqTrBS54eiJFQdkYb41YmvvowkEchs/A1YEkPUch8fjjVkpuQRywExdvtdex9B8w px/A== X-Forwarded-Encrypted: i=1; AJvYcCW77TlQZd0Ns7nrzbHXSVSC9Nl4N9I0Qh9cx56rLJq57K2MjPjrmAOor9FAaKSazjeh2RG//+ngKtYFVoVh@postgresql.org X-Gm-Message-State: AOJu0YxzNxx8sSVo5+PaWYwleqKPq4yZcxUyBZTAQZGbYGpOtdm0YCdk JLzkvWIO+djOmVebz2KL70ZQ66mfqEFVN2f4AvhjqUx8PvJX0nWtkzU1u4pmsYyHmuxXqKWYygw qI78cONDYzB8CviqNWnVy+JqRMSqH4Q== X-Gm-Gg: AeBDiesdFWONwRD690U8En1n8W51uZRzbR8OvphhfoxNqz/47hVUDTOd+k2KydPtchn vUxmbEpqOdN7xgv+VjTJwLMJ5rF5w4vZl4MOC3Vv6cblIYvCRs0i1XUZXQHY8N3WNi4HmqbEOXf soFP165a5JCuYDW/lPen/OdXcVTrM/LV3RL2O8mBewVlTvcEV/6Ivw7U1NFgCD9+Dp+pYjwms9y 1oXmE47rUS8dkRChKTiPAjwfW1oAoim5vFFK5obOOIFHWv79tV9TIh8efB52zLw8qkAOFuk9b55 X13iJiMm7MJbb83T1Z3kWniLIs834kNnKPRPXLI= X-Received: by 2002:ad4:5bc3:0:b0:8a5:fcce:4c with SMTP id 6a1803df08f44-8a7043edff1mr192922326d6.27.1775442758783; Sun, 05 Apr 2026 19:32:38 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shinya Kato Date: Mon, 6 Apr 2026 11:32:03 +0900 X-Gm-Features: AQROBzASiP1YjoXyX2wUbafpyz3Zd6MDG0OAol0U60sZ-FxDrxwdlAiBmu-QlHg Message-ID: Subject: Re: remove autoanalyze corner case To: Sami Imseih Cc: Nathan Bossart , Bharath Rupireddy , Robert Treat , satyanarlapuram@gmail.com, pgsql-hackers Content-Type: multipart/mixed; boundary="000000000000f4ff3d064ec17a02" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f4ff3d064ec17a02 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Apr 6, 2026 at 7:28=E2=80=AFAM Sami Imseih wr= ote: > > +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". Thanks, I've fixed it. --=20 Best regards, Shinya Kato NTT OSS Center --000000000000f4ff3d064ec17a02 Content-Type: application/octet-stream; name="v3-0001-remove-autoanalyze-corner-case.patch" Content-Disposition: attachment; filename="v3-0001-remove-autoanalyze-corner-case.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mnmkq9ko0 RnJvbSA0MDJmODdlZWY3ZDNmY2E0ZWRhMDVjZDU2ODdmYjEwZDU4OTc3M2U3IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBOYXRoYW4gQm9zc2FydCA8bmF0aGFuQHBvc3RncmVzcWwub3Jn PgpEYXRlOiBGcmksIDMgQXByIDIwMjYgMjE6NDk6MjQgLTA1MDAKU3ViamVjdDogW1BBVENIIHYz XSByZW1vdmUgYXV0b2FuYWx5emUgY29ybmVyIGNhc2UKCi0tLQogZG9jL3NyYy9zZ21sL21haW50 ZW5hbmNlLnNnbWwgICAgICAgfCAzICsrLQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUu c2dtbCAgfCA0ICsrKy0KIHNyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jIHwgOSAt LS0tLS0tLS0KIDMgZmlsZXMgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCspLCAxMSBkZWxldGlvbnMo LSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvbWFpbnRlbmFuY2Uuc2dtbCBiL2RvYy9zcmMv c2dtbC9tYWludGVuYW5jZS5zZ21sCmluZGV4IDBkMmEyODIwN2VkLi40MTJkNDFjNjM3YyAxMDA2 NDQKLS0tIGEvZG9jL3NyYy9zZ21sL21haW50ZW5hbmNlLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21s L21haW50ZW5hbmNlLnNnbWwKQEAgLTUzMSw3ICs1MzEsOCBAQAogICAgIGF1dG92YWN1dW0gaXMg aW52b2tlZCBvbiBhbnkgdGFibGUgdGhhdCBtaWdodCBjb250YWluIHVuZnJvemVuIHJvd3Mgd2l0 aAogICAgIFhJRHMgb2xkZXIgdGhhbiB0aGUgYWdlIHNwZWNpZmllZCBieSB0aGUgY29uZmlndXJh dGlvbiBwYXJhbWV0ZXIgPHhyZWYKICAgICBsaW5rZW5kPSJndWMtYXV0b3ZhY3V1bS1mcmVlemUt bWF4LWFnZSIvPi4gIChUaGlzIHdpbGwgaGFwcGVuIGV2ZW4gaWYKLSAgICBhdXRvdmFjdXVtIGlz IGRpc2FibGVkLikKKyAgICBhdXRvdmFjdXVtIGlzIGRpc2FibGVkLiAgSW4gdGhhdCBjYXNlLCBv bmx5IDxjb21tYW5kPlZBQ1VVTTwvY29tbWFuZD4gaXMKKyAgICBwZXJmb3JtZWQ7IDxjb21tYW5k PkFOQUxZWkU8L2NvbW1hbmQ+IGlzIHNraXBwZWQuKQogICAgPC9wYXJhPgogCiAgICA8cGFyYT4K ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwgYi9kb2Mvc3Jj L3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sCmluZGV4IDgwODI5YjIzOTQ1Li41YTFjNDYwYmQ5 NyAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbAorKysgYi9k b2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sCkBAIC0xNjgzLDcgKzE2ODMsOSBAQCBX SVRIICggTU9EVUxVUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bnVtZXJpY19saXRl cmFsPC9yZXBsYWNlYWJsZT4sIFJFTQogICAgICBhbmQvb3IgPGNvbW1hbmQ+QU5BTFlaRTwvY29t bWFuZD4gb3BlcmF0aW9ucyBvbiB0aGlzIHRhYmxlIGZvbGxvd2luZyB0aGUgcnVsZXMKICAgICAg ZGlzY3Vzc2VkIGluIDx4cmVmIGxpbmtlbmQ9ImF1dG92YWN1dW0iLz4uCiAgICAgIElmIGZhbHNl LCB0aGlzIHRhYmxlIHdpbGwgbm90IGJlIGF1dG92YWN1dW1lZCwgZXhjZXB0IHRvIHByZXZlbnQK LSAgICAgdHJhbnNhY3Rpb24gSUQgd3JhcGFyb3VuZC4gU2VlIDx4cmVmIGxpbmtlbmQ9InZhY3V1 bS1mb3Itd3JhcGFyb3VuZCIvPiBmb3IKKyAgICAgdHJhbnNhY3Rpb24gSUQgd3JhcGFyb3VuZC4g IEluIHRoYXQgY2FzZSwgb25seSA8Y29tbWFuZD5WQUNVVU08L2NvbW1hbmQ+CisgICAgIGlzIHBl cmZvcm1lZDsgPGNvbW1hbmQ+QU5BTFlaRTwvY29tbWFuZD4gaXMgc2tpcHBlZC4KKyAgICAgU2Vl IDx4cmVmIGxpbmtlbmQ9InZhY3V1bS1mb3Itd3JhcGFyb3VuZCIvPiBmb3IKICAgICAgbW9yZSBh Ym91dCB3cmFwYXJvdW5kIHByZXZlbnRpb24uCiAgICAgIE5vdGUgdGhhdCB0aGUgYXV0b3ZhY3V1 bSBkYWVtb24gZG9lcyBub3QgcnVuIGF0IGFsbCAoZXhjZXB0IHRvIHByZXZlbnQKICAgICAgdHJh bnNhY3Rpb24gSUQgd3JhcGFyb3VuZCkgaWYgdGhlIDx4cmVmIGxpbmtlbmQ9Imd1Yy1hdXRvdmFj dXVtIi8+CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9wb3N0bWFzdGVyL2F1dG92YWN1dW0uYyBi L3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jCmluZGV4IDg0MDBlNjcyMmNjLi44 NTdlNDQwMzRkOSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9hdXRvdmFjdXVt LmMKKysrIGIvc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9hdXRvdmFjdXVtLmMKQEAgLTMzMjksMTUg KzMzMjksNiBAQCByZWxhdGlvbl9uZWVkc192YWNhbmFseXplKE9pZCByZWxpZCwKIAkJc2NvcmVz LT5tYXggPSBNYXgoc2NvcmVzLT5tYXgsIHNjb3Jlcy0+YW5sKTsKIAkJaWYgKGF2X2VuYWJsZWQg JiYgYW5sdHVwbGVzID4gYW5sdGhyZXNoKQogCQkJKmRvYW5hbHl6ZSA9IHRydWU7Ci0KLQkJLyoK LQkJICogRm9yIGhpc3RvcmljYWwgcmVhc29ucywgd2UgYW5hbHl6ZSBldmVuIHdoZW4gYXV0b3Zh Y3V1bSBpcyBkaXNhYmxlZAotCQkgKiBmb3IgdGhlIHRhYmxlIGlmIGF0IHJpc2sgb2Ygd3JhcGFy b3VuZC4gIEl0J3Mgbm90IGNsZWFyIGlmIHRoaXMgaXMKLQkJICogaW50ZW50aW9uYWwsIGJ1dCBp dCBoYXMgYmVlbiB0aGlzIHdheSBmb3IgYSB2ZXJ5IGxvbmcgdGltZSwgc28gaXQKLQkJICogc2Vl bXMgYmVzdCB0byBhdm9pZCBjaGFuZ2luZyBpdCB3aXRob3V0IGZ1cnRoZXIgZGlzY3Vzc2lvbi4K LQkJICovCi0JCWlmIChmb3JjZV92YWN1dW0gJiYgQXV0b1ZhY3V1bWluZ0FjdGl2ZSgpICYmIGFu bHR1cGxlcyA+IGFubHRocmVzaCkKLQkJCSpkb2FuYWx5emUgPSB0cnVlOwogCX0KIAogCWlmICh2 YWNfaW5zX2Jhc2VfdGhyZXNoID49IDApCi0tIAoyLjQ3LjMKCg== --000000000000f4ff3d064ec17a02--