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 1vEZmy-00DZwh-R4 for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Oct 2025 21:02:32 +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 1vEZmw-00AVbX-SG for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Oct 2025 21:02:29 +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.94.2) (envelope-from ) id 1vEZmw-00AVbN-H1 for pgsql-hackers@lists.postgresql.org; Thu, 30 Oct 2025 21:02:29 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vEZmt-004ceY-39 for pgsql-hackers@postgresql.org; Thu, 30 Oct 2025 21:02:28 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-430c180d829so5976645ab.3 for ; Thu, 30 Oct 2025 14:02:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761858147; x=1762462947; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=VHN7++qmg/c6rotJgAphRu1VXx6CFTyHRaxvj+34J6U=; b=Z6VULxobR90B1s20nApVsURsAK0UrZSAX0glFJT4EkgqjVv+b2dFWhoSXvcLxyTN9j 8NxHeU9/uH8VuhHczhsIffYjheZ0332C14myBe7qqQB3l8jhM4Grsqpco8eOo7r37vLm +OE2O83sgQ3A6mob0rat5F+sJrjd8QKveFJTHDegddINjYw0UesguS9jZfgMQqserXxf S18cwKTo9E4tXCiueBMd5ghm8jpdZhxZ/1bWHbuDcZJgL6j2Xv464RuO3Uwo7/mnTLAu C1S7KgN6Kad84rIyGVj3jPWO1Y4wTa+PlPiqjhEqYes7EAet3kIfdQfngYwWFwisaJzc 4lkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761858147; x=1762462947; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=VHN7++qmg/c6rotJgAphRu1VXx6CFTyHRaxvj+34J6U=; b=pt88/DrIQp079bLerpFy6696YwVjXh2Ygw6tPxEFw+Pws3yAou5xx/BNNpORF6NIuu FJt+W1+PNF45id6bafn1oG/BosYRGByCHwtMN1yhZimr7jZ+h0E5wgKrsckW7Nc1UOJP SUNzy3QeJ+S1YZ7dpzUJNHtaky1OIFXZEyQRhbsyceGM1dGL0nSXO3Km56diCOyLpJoc t4hmUv/CEyhHqzpmxKKgZJ3fCxDj2qKTTnYCTuBxoSJoYecwlMnBZg2KywYD5qM5CZBL AsAa4thSjvtANjKv0VNgKKWZQtGQcLe7KyZ6aanA+n4AuGOebKV0zIb09D0mhG734BFP su+Q== X-Forwarded-Encrypted: i=1; AJvYcCU3UlqzsY6Wu+DyK7msEB8qQT5Tp4/EQ6e8WEv28rQHxT9JcFQyYzBpaHbvHfB6d4wHYeqRZYTsWM6YSbCh@postgresql.org X-Gm-Message-State: AOJu0YxUZnOrnb2yxSD8Mp4viGefl/zBvU0RFRfzzgqFHmcq32UIDxEr yM8b1Kr/ZjhPblLWBt5qIgOW9Ub9foCXxHr/ss7g8mYW/swwl38ifX1T X-Gm-Gg: ASbGncsLU4ZaxvOuWU1+M9EV/kSz4DCUiVobIbDud3O7/KpdwVRSti/ErDNM7iukoB2 e32QD4f2dSCM90722RjRBcarnYOLr/lzvf5WFHDWLJEi4eUYGi8AgZSWuz56vHGsH33zwGINDS5 plpba24DxXwWZahTglD5jkRcSALvpa+s02Gor3a2EsOaEj2Gjg44CMHdD69Yg+69ZiGDPf2kzvk DIzKKLXlOTg27OEXhhGsEGz8F9xB91XlnfgboLeij3lmO53gf809SUsoMMdZBiCg4utPk/BWoeQ jny2LU35SUvQTUgsmwCg9PvjK+Dbihm8gQWExQKr26qwsa9zmwtZySbRfuJ8kxxYCUkMqF0VUFe ifP+/1yfyTrAyKcodJp7Q2EowrNizIQLIKJmxz+AwHOm8CLq8VhXrdvkrFQLcL6IRyDvK2ni5TF k8C8M+Ras5znCYyu1DjP32gh3+PzHZFRaIFmROD04hXpmFc18/nAk8zjKyoeSc+ANmfQ== X-Google-Smtp-Source: AGHT+IE8bmnTqEe98Likuvcii2rZTGahv4eUVFxGq+fiioDFdcEXqg1mkipEHsA6b/ZSF+rtk0+wyw== X-Received: by 2002:a05:6e02:348e:b0:430:bee3:34a with SMTP id e9e14a558f8ab-4330d1a9628mr17666095ab.20.1761858146951; Thu, 30 Oct 2025 14:02:26 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-4330a6ffddesm4688035ab.27.2025.10.30.14.02.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 30 Oct 2025 14:02:26 -0700 (PDT) Date: Thu, 30 Oct 2025 16:02:24 -0500 From: Nathan Bossart To: Robert Haas Cc: Sami Imseih , David Rowley , Jeremy Schneider , pgsql-hackers@postgresql.org Subject: Re: another autovacuum scheduling thread Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Oct 30, 2025 at 04:05:19PM -0400, Robert Haas wrote: > 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. Yes. I've been thinking through how I want to test this but have yet to actually do so. If you have ideas, I'm all ears. -- nathan