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 1wBefW-001G4I-0H for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Apr 2026 20:11:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wBefS-000Juf-0p for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Apr 2026 20:10:59 +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 1wBefR-000JuX-2u for pgsql-hackers@lists.postgresql.org; Sat, 11 Apr 2026 20:10:58 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wBefQ-00000000Z1E-1BLz for pgsql-hackers@lists.postgresql.org; Sat, 11 Apr 2026 20:10:58 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-b9c1da7ac63so488366166b.0 for ; Sat, 11 Apr 2026 13:10:55 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775938253; cv=none; d=google.com; s=arc-20240605; b=kBjz2sUot0mxINhjdbha7aKYA9yGCd+drIlQkedBG7hpmhddbtw86k6/nMiBFSYc0Y SDTaozZbGsgfAevdoXIjJXgWec3fslS18QzekSz8kf0YUaDcDaanB9U3kdAkOYw/i1YF edBiWWXXuT76LmuB1Y/m/Tpe2lo3l19/LEBcii8GWregRUT22nfU5cUzwW6w7Q674zrv KO8SfFLjiu935qtH7A6wWYxQ7JGgaAptOekIXm1g21Vf0dmRMEHnf+smPZXrC4QsMWDY hc2TkEAKsojV3tBZwzxv0SrfdGdMnnQaLbG3F5C2kcoXeMB2UnDvDTBSOLjVJYDaxf1t GcLg== 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=x/xwIHew4ozlhMl1IP32oivqptM0fSqw8CclpmX4mME=; fh=Cy7sxeVuHuUdoW2bYuvlrSjwTTEhpess98gOtwA9NK0=; b=a6YX96PTcCvo0nS3Z29JYmTTZnueRGk92xfqPPl0CrJCcCbzUXiMwMe4eTH9u8oQT3 eh46t8dyTSkQol1EPmSl50dURfce7ttr2rk4hq+MZhuitmUz8n59R2jCFElbGDKWAdPB j1cd69+hZOu2M8tz34WIeYQVk/aybP1jF4AW6pXrMV+TikDc6dy5cgz4dppY1XE+UVLl 5+sMK8myPBkjvbQ0Gw40aP0BAFhujDfD55iuZg0Dv0SrqQfcvyKYhnp4zl/fobHs9P5+ 51wr3UdnQ/Rbzz1kuRBD2FyqUA8AvW70YzMkBYfXQLAZdVuBsLiE7/XDkQkmyprN0yM8 iywQ==; darn=lists.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=1775938253; x=1776543053; darn=lists.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=x/xwIHew4ozlhMl1IP32oivqptM0fSqw8CclpmX4mME=; b=cC73Rm7trqVKuEKqfHo5jY0Dn8VTXE/czeOlXzfX8kZgdEru4nI+zQmnRbUUrCgz2i MaqtCHBZ9OQJ9OVmOia8t5Lm34kR33P2IfWmQ4hnoglu1JJzHQsFns4xrottb72QHClE LKD6JHPVvW+b165GUzYXybrZhv4saCZEm7DHMNUFeLCArV4oal4LEf3yv28dOY+D+rfd J90jafJ3sZs2E8gtK6vCitxEA9VBCvEIx/5YQFbnoRlGuGPUKUPPkcfAcn3Wysz71Ztw ZBB+UFrkQ479bzfMKW7Tnn8h1vvhIVXZOM/xlxEBZQcFDay5Jvv0GjotV6pQ1ugcPNr2 55Tw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775938253; x=1776543053; 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=x/xwIHew4ozlhMl1IP32oivqptM0fSqw8CclpmX4mME=; b=tLBq6Tpv6PVXw+GZKbJDwUQ7/C9ZBlQLVwF7ca5wy+Kt8HTI/yUXTIWCzt5djpcy1S wSlRClrK8AkYcTV6DgMVyoIo8OcjrhyEr/XTmFDIxM2cFwD+nmMgUaIsUxEusckeerQS rbQ/aWknkkEorvpeLXzuXFge3zhT/qgO8CW1aZZPkofUsMHVup8ogH2Tn9MjY1rXCqWf 6dgr+FC/oY/n3gsVRuONKkvJiuDEcjkBMP9PV6/jyxsVqTPff0zFDrHk0ZwmFfG7D7F9 PPC1euGTQHXiv4i3Ihe7xEXEdPTlWEU97FeOfFiXEZUSCYfeh3eByiqva8vm3HOw0fjV h8Aw== X-Forwarded-Encrypted: i=1; AJvYcCXYSbQ6E0daQswY99FJgtElwLCMw5+REwjAYiFlBUARRJzuFaFiTF6aNMWe0egM62QusPQ0GZQ7efDBpIYg@lists.postgresql.org X-Gm-Message-State: AOJu0Yx0I8DdpaiJR5QCzKzGD+vn5aay3qBAFibtJp2csFPY53pwnQdW 2UIB4cuuzsSN9K27i+Qi6prt5aT4zb+HADJwF51pQS1DxNsoB6hMXSyOm8yTud1w+DZt/Y+x62g 8ZgI4s58x9HWvQN7tOtKC+Yy350hGNas= X-Gm-Gg: AeBDietYvCrSoDi9cUEMasg5KY1He+1hf2LWJlfPgpWFCHZhT2+Y0k4z00GOxsRekt2 oFFPBjjiL2pVvk/s8cl/iPEa6LosktsIVBRG35fddIN2yMd2WTsiLR52arNJo2rH41Z5kVGG2Cm bhDvZoJ+QQU/xXxg66kfiFaD7PpVlkdbvfoNTXnwwEwjNSdwvWiltI2zzMnRo8aHMhuaQPe1qDF Gc/CyY/eM3En75jPKef1hf4sOWs7I21CsfJePao0l4AubDVR6YMUWRZzwyqXneZqbRk3i6qWP3v EKmI8Q== X-Received: by 2002:a17:907:1582:b0:b97:6147:def1 with SMTP id a640c23a62f3a-b9d727aa511mr312341966b.33.1775938253273; Sat, 11 Apr 2026 13:10:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sami Imseih Date: Sat, 11 Apr 2026 15:10:42 -0500 X-Gm-Features: AQROBzBo310vdJzIRhjbC9QX2hnzosl74SPqSZ6nKMtD_puMmyoSb5gkN4H_5T0 Message-ID: Subject: Re: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops To: Dapeng Wang Cc: Lakshmi N , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, It was discussed [1] here if C_F_I is needed in these do_autovacuum/autovacuum_scores code paths, and it was decided not to add them. Also, at least on my tests with 100k evern with 1 million tables, I did not see a reason to do so. These are catalog scans that should happen quick enough, even in extreme cases, to not make this worthwhile. Others may have another opinion. -- Sami [1] [https://www.postgresql.org/message-id/acwTxpz3Toxt0ty8%40nathan]