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 1vEYtu-00DM0z-QL for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Oct 2025 20:05:38 +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 1vEYtt-00AFTV-RD for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Oct 2025 20:05:36 +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 1vEYtt-00AFTN-HS for pgsql-hackers@lists.postgresql.org; Thu, 30 Oct 2025 20:05:36 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vEYtp-0057ix-2M for pgsql-hackers@postgresql.org; Thu, 30 Oct 2025 20:05:35 +0000 Received: by mail-ej1-x62c.google.com with SMTP id a640c23a62f3a-b3e7cc84b82so333390766b.0 for ; Thu, 30 Oct 2025 13:05:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761854732; x=1762459532; darn=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=y4rTjRd0/cf0piS+EeLmLYiQIisjTW8PXQ2dlMjPVjY=; b=fmIu8D/onqlB4HpEmjPN0JosEektTSKtndT2fxeXzChxnNXKnTST8BLrQKu1RnDGxI wWVxpAah6qFxg65watTg4gUhAClDKYdRDP63Es8iyPyGqlX5iOIS7SD4Se2vR6n+GSZ5 wQbRHwkKsJM4SGyHYUSYmu5W9zYwCgjsQ1s80d/E6NUIAK0EYM3uuzcjT1yhn82N/WhC XkP0J4rcvXDe50o2vwXdpqOo3k5SF6Lr5+4xlPrsxU5sXVSgnxE610z5wnUop4gcqwZZ /NicDDGjBxLBdP0ChjjagYvb+00xws8EMg6mBT5l6TsPl7EG/GLbbwsgAMTh8IR0OnkK i4ig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761854732; x=1762459532; 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=y4rTjRd0/cf0piS+EeLmLYiQIisjTW8PXQ2dlMjPVjY=; b=YDICUpREkJwHdzhgZKBONmda5Gn5UFwSC304xZQN6ZbxaR+5md0kIS2q3933zOenl+ 4Y4MlywV3Ug9+dF7U1L0vdifbdzmU/bUAz+a8h21rp6XEhlQomlvhfStPoUbVvPjpTCS axX9bilMQBB5VjOb8mU+v30T5MQ6I7okqlxSKrGK6g/qUcNhEM42AUgf+1Q1JQj+2vhZ YCbGSOwdznQr/wL4ogUIlmD2xyo89I3p/3CjVQ7trueZXzQT0xbrl57bRaNfFDu1eed6 ymNPV94tSFl65kfC+A/j31FiXwtkfRLN84jSFCxwIFMOjNqZpOm9+1SMsoPxHHyadG9s ydIA== X-Forwarded-Encrypted: i=1; AJvYcCVUeegsQq9vBP88dnUv3i0gMsT4hG+JruRSjT7G8sBccmcwFaeyVwNyrPK79mCtPf+8xlpzuxQGPPtF2rrt@postgresql.org X-Gm-Message-State: AOJu0YxBOMutWH6AqluWdNNQ31cLwAv2W2qo5ND/SWrCe0z1AlLW082z 96bTpJtw1BDErLVsDS8ey3c/LsA3bL+7DPUl9YF4zp3Uc+RqcuCM6fLElTRgfayROpO/fFuFhvY KTnsqhc0PIXB5cBNKidKktrPsZIyhlvQ= X-Gm-Gg: ASbGncvQP3VxV+hluegfHLAFK7jYHwAPhZRo+H+O7TfYtGUyjZXEC3ZnHDzBXonzZ/U cXd8oQsPJoxDc+/Lmqa8dwZ5MS3QwspQVuPrev9aR38q2GAkQ5HUB2UvP5mWX7P5FvwTN+AGRYC tuoq2e5z5yYAJVYrne3Oaj2dAubywzgpFnkrMvKDyCeJpUAPmM11ha91rhrMPt5DDxkrmDpLf+Y wFkpHDrcOEHNzefyLDW1283oYIlV2juFnvl2rwmXO6Nvzk4OBCzk6jMRRdpJLPBWI75l7Q= X-Google-Smtp-Source: AGHT+IFHUU9KcbKZ8LH7nGWnKSQ1uqgRCV2bF6EjHzzkbrI3exFeE6+ARjaZxd5qOk/8/UdxC8aQoEugmWKhuAZ4P8A= X-Received: by 2002:a17:906:a24f:b0:b6d:6c8f:6af6 with SMTP id a640c23a62f3a-b7070139726mr68319966b.16.1761854732390; Thu, 30 Oct 2025 13:05:32 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Haas Date: Thu, 30 Oct 2025 16:05:19 -0400 X-Gm-Features: AWmQ_bmvUCOP_CvUNmYKayFToBjrwzgsgrmyOaSGM9n_9iRhbGid3eO0ha6lt08 Message-ID: Subject: Re: another autovacuum scheduling thread To: Nathan Bossart Cc: Sami Imseih , David Rowley , Jeremy Schneider , pgsql-hackers@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 Wed, Oct 29, 2025 at 11:51=E2=80=AFAM Nathan Bossart wrote: > Oops. I fixed that typo in v7. Are you planning to do some practical experimentation with this? I feel like it would be a good idea to set up some kind of a test case where this is expected to provide a benefit and see if it actually does; and also maybe set up a test case where it will reorder the tables but with no practical difference in the outcome expected and verify that, in fact, nothing changes. --=20 Robert Haas EDB: http://www.enterprisedb.com