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 1w68wf-003zqO-1j for pgsql-committers@arkaria.postgresql.org; Fri, 27 Mar 2026 15:17:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w68wd-00ARwF-33 for pgsql-committers@arkaria.postgresql.org; Fri, 27 Mar 2026 15:17:56 +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 1w68wd-00ARw7-1u for pgsql-committers@lists.postgresql.org; Fri, 27 Mar 2026 15:17:56 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w68wc-00000001Kxd-0Mba for pgsql-committers@lists.postgresql.org; Fri, 27 Mar 2026 15:17:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=uPzoROgLcW1O0dx8Svt+xDJw/MbGhJCpwvwoXoXgtTc=; b=EgZcEbXM3+9/hUkFcUktesBq9C alTeAax+MlTxQjC5lDc6sfGEklKW9sG4pYJ221LMUIFG40rKT5nwfw7mRmGEG8Cb0W43wulNvQvwx LEmvykV1P09ng8Qq5PRf/lM2n/CmrWJwkMU4dgaALmYryObGeDR2DmxMWC1R9pw9FKP1ioDFd8Jz+ wr4M6pYCOmrTEWShbaB+FLEyku373JUeBRkgicrvAw72/ICva5DOTY8qiNWBEamSjycqkoL3/qyPS sP/gMjzeFoiiIjNx8VHJE5F+z3gjih0rXZ7cEecAFW83ZrbHhX0pcTuATSsuKaUR74h1Xn1CKp99/ 2ZlUL9+Q==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w68wb-005Mp8-2U for pgsql-committers@lists.postgresql.org; Fri, 27 Mar 2026 15:17:53 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w68wa-001iA8-2c for pgsql-committers@lists.postgresql.org; Fri, 27 Mar 2026 15:17:53 +0000 Content-Type: multipart/mixed; boundary="===============6723979926621261593==" MIME-Version: 1.0 From: Nathan Bossart To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add rudimentary table prioritization to autovacuum. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 27 Mar 2026 15:17:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6723979926621261593== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHJ1ZGltZW50YXJ5IHRhYmxlIHByaW9yaXRpemF0aW9uIHRvIGF1dG92YWN1dW0uCgpBdXRv dmFjdXVtIHdvcmtlcnMgc2NhbiBwZ19jbGFzcyB0d2ljZSB0byBjb2xsZWN0IHRoZSBzZXQgb2Yg dGFibGVzCnRvIHByb2Nlc3MuICBUaGUgZmlyc3QgcGFzcyBpcyBmb3IgcGxhaW4gcmVsYXRpb25z IGFuZCBtYXRlcmlhbGl6ZWQKdmlld3MsIGFuZCB0aGUgc2Vjb25kIGlzIGZvciBUT0FTVCB0YWJs ZXMuICBXaGVuIHRoZSB3b3JrZXIgZmluZHMgYQp0YWJsZSB0byBwcm9jZXNzLCBpdCBhZGRzIGl0 IHRvIHRoZSBlbmQgb2YgYSBsaXN0LiAgTGF0ZXIgb24sIGl0CnByb2Nlc3NlcyB0aGUgdGFibGVz IGluIHRoZSBzYW1lIG9yZGVyIGFzIHRoZSBsaXN0LiAgVGhpcyBzaW1wbGUKc3RyYXRlZ3kgaGFz IHdvcmtlZCBzdXJwcmlzaW5nbHkgd2VsbCBmb3IgYSBsb25nIHRpbWUsIGJ1dCB0aGVyZQpoYXZl IGJlZW4gbWFueSBkaXNjdXNzaW9ucyBvdmVyIHRoZSB5ZWFycyBhYm91dCB0cnlpbmcgdG8gaW1w cm92ZQppdC4KClRoaXMgY29tbWl0IGludHJvZHVjZXMgYSBzY29yaW5nIHN5c3RlbSB0aGF0IGlz IHVzZWQgdG8gc29ydCB0aGUKYWZvcmVtZW50aW9uZWQgbGlzdCBvZiB0YWJsZXMgdG8gcHJvY2Vz cy4gIFRoZSBpZGVhIGlzIHRvIGhhdmUKYXV0b3ZhY3V1bSB3b3JrZXJzIHByaW9yaXRpemUgdGFi bGVzIHRoYXQgYXJlIGZ1cnRoZXN0IGJleW9uZCB0aGVpcgp0aHJlc2hvbGRzIChlLmcuLCBhIHRh YmxlIG5lYXJpbmcgdHJhbnNhY3Rpb24gSUQgd3JhcGFyb3VuZCBzaG91bGQKYmUgdmFjdXVtZWQg Zmlyc3QpLiAgVGhpcyBwcmlvcml0aXphdGlvbiBzY2hlbWUgaXMgY2VydGFpbmx5IGZhcgpmcm9t IHBlcmZlY3Q7IHRoZXJlIGFyZSBzaW1wbHkgdG9vIG1hbnkgcG9zc2liaWxpdGllcyBmb3IgYW55 CnNjb3JpbmcgdGVjaG5pcXVlIHRvIHdvcmsgYWNyb3NzIGFsbCB3b3JrbG9hZHMsIGFuZCB0aGUg c2l0dWF0aW9uCm1pZ2h0IGNoYW5nZSBzaWduaWZpY2FudGx5IGJldHdlZW4gdGhlIHRpbWUgd2Ug Y2FsY3VsYXRlIHRoZSBzY29yZQphbmQgdGhlIHRpbWUgdGhhdCBhdXRvdmFjdXVtIHByb2Nlc3Nl cyBpdC4gIEhvd2V2ZXIsIHdlIGhhdmUKYXR0ZW1wZWQgdG8gZGV2ZWxvcCBzb21ldGhpbmcgdGhh dCBpcyBleHBlY3RlZCB0byB3b3JrIGZvciBhIGxhcmdlCnBvcnRpb24gb2Ygd29ya2xvYWRzIHdp dGggcmVhc29uYWJsZSBwYXJhbWV0ZXIgc2V0dGluZ3MuCgpUaGUgc2NvcmUgaXMgY2FsY3VsYXRl ZCBhcyB0aGUgbWF4aW11bSBvZiB0aGUgcmF0aW9zIG9mIGVhY2ggb2YgdGhlCnRhYmxlJ3MgcmVs ZXZhbnQgdmFsdWVzIHRvIGl0cyB0aHJlc2hvbGQuICBGb3IgZXhhbXBsZSwgaWYgdGhlCm51bWJl ciBvZiBpbnNlcnRlZCB0dXBsZXMgaXMgMTAwLCBhbmQgdGhlIGluc2VydCB0aHJlc2hvbGQgZm9y IHRoZQp0YWJsZSBpcyA4MCwgdGhlIGluc2VydCBzY29yZSBpcyAxLjI1LiAgSWYgYWxsIG90aGVy IHNjb3JlcyBhcmUKYmVsb3cgdGhhdCB2YWx1ZSwgdGhlIHRhYmxlJ3Mgc2NvcmUgd2lsbCBiZSAx LjI1LiAgVGhlIG90aGVyCmNyaXRlcmlhIGNvbnNpZGVyZWQgZm9yIHRoZSBzY29yZSBhcmUgdGhl IHRhYmxlIGFnZXMgKGJvdGgKcmVsZnJvemVueGlkIGFuZCByZWxtaW5teGlkKSBjb21wYXJlZCB0 byB0aGUgY29ycmVzcG9uZGluZwpmcmVlemUtbWF4LWFnZSBzZXR0aW5nLCB0aGUgbnVtYmVyIG9m IHVwZGF0ZS9kZWxldGVkIHR1cGxlcwpjb21wYXJlZCB0byB0aGUgdmFjdXVtIHRocmVzaG9sZCwg YW5kIHRoZSBudW1iZXIgb2YKaW5zZXJ0ZWQvdXBkYXRlZC9kZWxldGVkIHR1cGxlcyBjb21wYXJl ZCB0byB0aGUgYW5hbHl6ZSB0aHJlc2hvbGQuCgpPbmNlIGV4Y2VwdGlvbiB0byB0aGUgcHJldmlv dXMgcGFyYWdyYXBoIGlzIGZvciB0YWJsZXMgbmVhcmluZwp3cmFwYXJvdW5kLCBpLmUuLCB0aG9z ZSB0aGF0IGhhdmUgc3VycGFzc2VkIHRoZSBlZmZlY3RpdmUgZmFpbHNhZmUKYWdlcy4gIEluIHRo YXQgY2FzZSwgdGhlIHJlbGZyb3plbnhpZC9yZWxtaW5teGlkLWJhc2VkIHNjb3JlIGlzCnNjYWxl ZCBhZ2dyZXNzaXZlbHkgc28gdGhhdCB0aGUgdGFibGUgaGFzIGEgZGVjZW50IGNoYW5jZSBvZgpz b3J0aW5nIHRvIHRoZSBmcm9udCBvZiB0aGUgbGlzdC4KClRvIGFkanVzdCBob3cgc3Ryb25nbHkg ZWFjaCBjb21wb25lbnQgY29udHJpYnV0ZXMgdG8gdGhlIHNjb3JlLCB0aGUKZm9sbG93aW5nIHBh cmFtZXRlcnMgY2FuIGJlIGFkanVzdGVkIGZyb20gdGhlaXIgZGVmYXVsdCBvZiAxLjAgdG8KYW55 d2hlcmUgYmV0d2VlbiAwLjAgYW5kIDEwLjAgKGluY2x1c2l2ZSkuICBTZXR0aW5nIGFsbCBvZiB0 aGVzZSB0bwowLjAgcmVzdG9yZXMgcHJlLXYxOSBwcmlvcml0aXphdGlvbiBiZWhhdmlvcjoKCiAg ICAgICAgYXV0b3ZhY3V1bV9mcmVlemVfc2NvcmVfd2VpZ2h0CiAgICAgICAgYXV0b3ZhY3V1bV9t dWx0aXhhY3RfZnJlZXplX3Njb3JlX3dlaWdodAogICAgICAgIGF1dG92YWN1dW1fdmFjdXVtX3Nj b3JlX3dlaWdodAogICAgICAgIGF1dG92YWN1dW1fdmFjdXVtX2luc2VydF9zY29yZV93ZWlnaHQK ICAgICAgICBhdXRvdmFjdXVtX2FuYWx5emVfc2NvcmVfd2VpZ2h0CgpUaGlzIGlzIGludGVuZGVk IHRvIGJlIGEgYmFieSBzdGVwIHRvd2FyZHMgc21hcnRlciBhdXRvdmFjdXVtCndvcmtlcnMuICBQ b3NzaWJsZSBmdXR1cmUgaW1wcm92ZW1lbnRzIGluY2x1ZGUsIGJ1dCBhcmUgbm90IGxpbWl0ZWQK dG8sIHBlcmlvZGljIHJlcHJpb3JpdGl6YXRpb24sIGF1dG9tYXRpYyBjb3N0IGxpbWl0IGFkanVz dG1lbnRzLAphbmQgYmV0dGVyIG9ic2VydmFiaWxpdHkgKGUuZy4sIGEgc3lzdGVtIHZpZXcgdGhh dCBzaG93cyBjdXJyZW50CnNjb3JlcykuICBXaGlsZSB3ZSBkbyBub3QgZXhwZWN0IHRoaXMgY29t bWl0IHRvIHByb2R1Y2UgYW55CmVhcnRoLXNoYXR0ZXJpbmcgaW1wcm92ZW1lbnRzLCBpdCBpcyBh cmd1YWJseSBhIHByZXJlcXVpc2l0ZSBmb3IKdGhlIGFmb3JlbWVudGlvbmVkIGZvbGxvdy11cCBj aGFuZ2VzLgoKUmV2aWV3ZWQtYnk6IFNhbWkgSW1zZWloIDxzYW1pbXNlaWhAZ21haWwuY29tPgpS ZXZpZXdlZC1ieTogRGF2aWQgUm93bGV5IDxkZ3Jvd2xleW1sQGdtYWlsLmNvbT4KUmV2aWV3ZWQt Ynk6IFJvYmVydCBIYWFzIDxyb2JlcnRtaGFhc0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiB3ZW5o dWkgcWl1IDxxaXV3ZW5odWlmeEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBHcmVnIEJ1cmQgPGdy ZWdAYnVyZC5tZT4KUmV2aWV3ZWQtYnk6IEJoYXJhdGggUnVwaXJlZGR5IDxiaGFyYXRoLnJ1cGly ZWRkeWZvcnBvc3RncmVzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMv bS9hT2FBdVhSRXduUFpWSVNPJTQwbmF0aGFuCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWls cwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZDc5NjVk NjVmYzViYjIxMzliYzUxYzA1MWMxMTQyODQxNGM2NTE2MAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0t LS0tLS0tLS0KZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sICAgICAgICAgICAgICAgICAgICAgIHwg IDkwICsrKysrKysrCmRvYy9zcmMvc2dtbC9tYWludGVuYW5jZS5zZ21sICAgICAgICAgICAgICAg ICB8IDEwMyArKysrKysrKysrCnNyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jICAg ICAgICAgICB8IDI4MyArKysrKysrKysrKysrKysrKysrKystLS0tLQpzcmMvYmFja2VuZC91dGls cy9taXNjL2d1Y19wYXJhbWV0ZXJzLmRhdCAgICAgfCAgNDAgKysrKwpzcmMvYmFja2VuZC91dGls cy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgfCAgIDUgKwpzcmMvaW5jbHVkZS9wb3N0bWFz dGVyL2F1dG92YWN1dW0uaCAgICAgICAgICAgfCAgIDYgKy0Kc3JjL3Rvb2xzL3BnaW5kZW50L3R5 cGVkZWZzLmxpc3QgICAgICAgICAgICAgIHwgICAyICsKNyBmaWxlcyBjaGFuZ2VkLCA0ODEgaW5z ZXJ0aW9ucygrKSwgNDggZGVsZXRpb25zKC0pCgo= --===============6723979926621261593==--