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 1tuecL-00ATdM-OB for pgsql-committers@arkaria.postgresql.org; Tue, 18 Mar 2025 21:36:57 +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 1tuecK-0061ly-G8 for pgsql-committers@arkaria.postgresql.org; Tue, 18 Mar 2025 21:36: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.94.2) (envelope-from ) id 1tueZJ-005yi3-Rk for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 21:33:49 +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.96) (envelope-from ) id 1tueZD-003Zvs-1A for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 21:33:48 +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=hgcUo9PkNOyT/29TlesqYPm8S+dNYb7Vizd7X2v5wh8=; b=Zw438V8BN8IrTUeGidt1YrhaDc Y8bMrpxUydF027h4Yq0rInvM6XyKzaqz3lYCsp5BxLsE6Gsy/Az9jwCFTxz21aDvBD6OQ+eHwBQsv tSqXUO0inAccRfpUSwYMXVO2Cm0rkh/k3WqzjTepwKSjPDa/gqP4rg76YJLsctLcSMhQoK1OcikU0 jav/G1FYumxpvKktOA6LaEZfS7n0XYxxT3WMvD2lmvK4ge0me42CAoPTvfkeBL+XuJ9DZ1fzXhIiQ vAP9LeBFx+ulPAjHVnBgeZvxhgXBW+5JOdy284ZOWLz2YmXFVhuNCyFatfxnEY42s2mwUGNFtBxzv fFZ137mQ==; 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.94.2) (envelope-from ) id 1tueZD-009Oia-24 for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 21:33:43 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tueZC-0039rg-2J for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 21:33:42 +0000 Content-Type: multipart/mixed; boundary="===============2757592799541006995==" MIME-Version: 1.0 From: Nathan Bossart To: pgsql-committers@lists.postgresql.org Subject: pgsql: vacuumdb: Teach vacuum_one_database() to reuse query results. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 18 Mar 2025 21:33:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2757592799541006995== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 dmFjdXVtZGI6IFRlYWNoIHZhY3V1bV9vbmVfZGF0YWJhc2UoKSB0byByZXVzZSBxdWVyeSByZXN1 bHRzLgoKUHJlc2VudGx5LCBlYWNoIGNhbGwgdG8gdmFjdXVtX29uZV9kYXRhYmFzZSgpIHF1ZXJp ZXMgdGhlIGNhdGFsb2dzCnRvIHJldHJpZXZlIHRoZSBsaXN0IG9mIHRhYmxlcyB0byBwcm9jZXNz LiAgQSBmb2xsb3ctdXAgY29tbWl0IHdpbGwKYWRkIGEgIm1pc3Npbmcgc3RhdHMgb25seSIgZmVh dHVyZSB0byAtLWFuYWx5emUtaW4tc3RhZ2VzLCB3aGljaApyZXF1aXJlcyBzYXZpbmcgdGhlIGNh dGFsb2cgcXVlcnkgcmVzdWx0cyAoc2luY2UgdGFibGVzIHdpdGhvdXQKc3RhdGlzdGljcyB3aWxs IGhhdmUgdGhlbSBhZnRlciB0aGUgZmlyc3Qgc3RhZ2UpLiAgVGhpcyBjb21taXQgYWRkcwphIG5l dyBwYXJhbWV0ZXIgdG8gdmFjdXVtX29uZV9kYXRhYmFzZSgpIHRoYXQgc3BlY2lmaWVzIGVpdGhl ciBhCnByZXZpb3VzbHktcmV0cmlldmVkIGxpc3Qgb3IgYSBwbGFjZSB0byByZXR1cm4gdGhlIGNh dGFsb2cgcXVlcnkKcmVzdWx0cy4gIE5vdGUgdGhhdCBub3RoaW5nIHVzZXMgdGhpcyBuZXcgcGFy YW1ldGVyIHlldC4KCkF1dGhvcjogQ29yZXkgSHVpbmtlciA8Y29yZXkuaHVpbmtlckBnbWFpbC5j b20+CkNvLWF1dGhvcmVkLWJ5OiBOYXRoYW4gQm9zc2FydCA8bmF0aGFuZGJvc3NhcnRAZ21haWwu Y29tPgpSZXZpZXdlZC1ieTogSm9obiBOYXlsb3IgPGpvaG5jbmF5bG9ybHNAZ21haWwuY29tPgpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL1o1TzFicGN3RHJNZ3lyWXklNDBuYXRoYW4K CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85YzAzYzhkMTg3MjEwZjExMjM3MWFhYjg4MWIzNzliZDQ4 MDA1NjJjCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmluL3NjcmlwdHMvdmFj dXVtZGIuYyB8IDMzMCArKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0t LS0KMSBmaWxlIGNoYW5nZWQsIDE5NCBpbnNlcnRpb25zKCspLCAxMzYgZGVsZXRpb25zKC0pCgo= --===============2757592799541006995==--