Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pnJli-0004Ui-3n for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Apr 2023 13:47:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pnJlf-0007rN-GW for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Apr 2023 13:47:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pnJlf-0007rE-5o for pgsql-hackers@lists.postgresql.org; Fri, 14 Apr 2023 13:47:11 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pnJlc-002rxY-6n for pgsql-hackers@postgresql.org; Fri, 14 Apr 2023 13:47:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=XiG1AA/kBGNi0YCj0i2DGE2iDMRsVrzVn/1SdlAKqrw=; b=SZPv96mEzQEinJOps8wkmjrHdA UKVQYZ6oHYvehz4gsusNIFmXUppW4mm1qRPxFJgie0xJKAvAy5LntMEJx0u1XSxS70DYYnGYrRs5R iZMeqRT/BYquJ+qHUfVIwf4rnHBRQOpEIwllnRVwl+8xdvU1wZZyoL55jC06CKCBPaHC6+5thX5Un eCnkIF0g2VWCuY7so1O5Ap2fls4nacKahnvskhXh/rKEur86e+UrMyR4GFkrLbwp+AARAav/Uvdu6 5dtkS07gR50/MXA2qGfvwp1sRI68sQKhOvhDe4JxSH7ySS54zR7USuNkg38ONOKIIQ0jVPZJKMjga PgUXBHiA==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pnJlX-0006Fo-AA; Fri, 14 Apr 2023 13:47:05 +0000 Message-ID: <2755ebe5-5ab6-7509-cf47-c606be5583cd@postgresql.org> Date: Fri, 14 Apr 2023 09:46:59 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.9.1 Content-Language: en-US To: Robert Haas , Laurenz Albe Cc: Amit Kapila , Andres Freund , Justin Pryzby , Alvaro Herrera , pgsql-hackers@postgresql.org References: <20230317230930.nhsgk3qfk7f4axls@awork3.anarazel.de> <20230318093357.g4e3eexqg6dxmuel@alvherre.pgsql> <20230322170048.ffbnfr5o2jrjgb2f@awork3.anarazel.de> <20230411182010.zsldtjrxe5m2bqzp@awork3.anarazel.de> <490f1ebd-03fc-d996-cc5e-7991569a9e45@postgresql.org> From: "Jonathan S. Katz" Subject: Re: Should we remove vacuum_defer_cleanup_age? In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------TvKbiU6Y5XxbevazZjsRY6Q6" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------TvKbiU6Y5XxbevazZjsRY6Q6 Content-Type: multipart/mixed; boundary="------------Yng8auQ5nLFAKyQsouch129h"; protected-headers="v1" From: "Jonathan S. Katz" To: Robert Haas , Laurenz Albe Cc: Amit Kapila , Andres Freund , Justin Pryzby , Alvaro Herrera , pgsql-hackers@postgresql.org Message-ID: <2755ebe5-5ab6-7509-cf47-c606be5583cd@postgresql.org> Subject: Re: Should we remove vacuum_defer_cleanup_age? References: <20230317230930.nhsgk3qfk7f4axls@awork3.anarazel.de> <20230318093357.g4e3eexqg6dxmuel@alvherre.pgsql> <20230322170048.ffbnfr5o2jrjgb2f@awork3.anarazel.de> <20230411182010.zsldtjrxe5m2bqzp@awork3.anarazel.de> <490f1ebd-03fc-d996-cc5e-7991569a9e45@postgresql.org> In-Reply-To: --------------Yng8auQ5nLFAKyQsouch129h Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNC8xNC8yMyA4OjMwIEFNLCBSb2JlcnQgSGFhcyB3cm90ZToNCj4gT24gVGh1LCBBcHIg MTMsIDIwMjMgYXQgMTE6MDbigK9QTSBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJl cnRlYy5hdD4gd3JvdGU6DQo+PiBJIGFtIG5vdCBhZ2FpbnN0IHRoaXMgaW4gcHJpbmNpcGxl LCBidXQgSSBrbm93IHRoYXQgdGhlcmUgYXJlIHBlb3BsZSB1c2luZw0KPj4gdGhpcyBwYXJh bWV0ZXI7IHNlZSB0aGUgZGlzY3Vzc2lvbiBsaW5rZWQgaW4NCj4+DQo+PiBodHRwczovL3Bv c3Rnci5lcy9tL0Uxamt6eEUtMDAwNkR3LURnQGdlbXVsb24ucG9zdGdyZXNxbC5vcmcNCj4+ DQo+PiBJIGNhbid0IHNheSBpZiB0aGV5IGhhdmUgYSBnb29kIHVzZSBjYXNlIGZvciB0aGF0 IHBhcmFtZXRlciBvciBub3QuDQo+IA0KPiBZZWFoLCBJIGZlZWwgc2ltaWxhcmx5LiBBY3R1 YWxseSwgcGVyc29uYWxseSBJIGhhdmUgbm8gZXZpZGVuY2UsIG5vdA0KPiBldmVuIGFuIGFu ZWNkb3RlLCBzdWdnZXN0aW5nIHRoYXQgdGhpcyBwYXJhbWV0ZXIgaXMgaW4gdXNlLCBidXQg SSdtIGENCj4gYml0IHNrZXB0aWNhbCBvZiBhbnkgY29uc2Vuc3VzIG9mIHRoZSBmb3JtICJu byBvbmUgaXMgdXNpbmcgWCwiDQo+IGJlY2F1c2UgdGhlcmUgc3VyZSBhcmUgYSBsb3Qgb2Yg cGVvcGxlIHJ1bm5pbmcgUG9zdGdyZVNRTCBhbmQgdGhleQ0KPiBzdXJlIGRvIGEgbG90IG9m IHRoaW5ncy4gU29tZSBtb3JlIGp1c3RpZmlhYmx5IHRoYW4gb3RoZXJzLCBidXQgb2Z0ZW4N Cj4gcGVvcGxlIGhhdmUgc3VycHJpc2luZ2x5IGdvb2QgZXhjdXNlcyBmb3IgZG9pbmcgc3R1 ZmYgdGhhdCBzb3VuZHMNCj4gYml6YXJyZSB3aGVuIHlvdSBmaXJzdCBoZWFyIGFib3V0IGl0 LCBhbmQgaXQgZG9lc24ndCBzZWVtIHRvdGFsbHkNCj4gaW1wb3NzaWJsZSB0aGF0IHNvbWVi b2R5IGNvdWxkIGhhdmUgZm91bmQgYSB3YXkgdG8gZ2V0IHZhbHVlIG91dCBvZg0KPiB0aGlz Lg0KDQpMZXQgbWUgcmVzdGF0ZSBbMV0gaW4gYSBkaWZmZXJlbnQgd2F5Lg0KDQpVc2luZyBh IGxhcmdlIGVub3VnaCBkYXRhc2V0LCBJIGRpZCBxdWFsaXRhdGl2ZWx5IGxvb2sgYXQgb3Zl cmFsbCB1c2FnZSANCm9mIGJvdGggInZhY3V1bV9kZWZlcl9jbGVhbnVwX2FnZSIgYW5kIGNv bXBhcmVkIHRvIA0KImhvdF9zdGFuZGJ5X2ZlZWRiYWNrIiwgZ2l2ZW4geW91IGNhbiB1c2Ug Ym90aCB0byBhY2NvbXBsaXNoIHNpbWlsYXIgDQpvdXRjb21lcy4gVGhlIHVzYWdlIG9mICJ2 YWN1dW1fZGVmZXJfY2xlYW51cF9hZ2UiIHdhcyByZWFsbHkgbWluaW1hbCwgaW4gDQpmYWN0 IGFwcHJvYWNoaW5nICIwIiwgd2hlcmVhcyAiaG90X3N0YW5kYnlfZmVlZGJhY2siIGhhZCBz aWduaWZpY2FudCANCmFkb3B0aW9uLg0KDQpJJ20gbm90IHNheWluZyB0aGF0ICJ3ZSBzaG91 bGQgcmVtb3ZlIGEgc2V0dGluZyBqdXN0IGJlY2F1c2UgaXQncyBub3QgDQp1c2VkIiBvciB0 aGF0IGl0IG1heSBub3QgaGF2ZSB1dGlsaXR5IC0tIEknbSBzYXlpbmcgdGhhdCB3ZSBjYW4g cmVtb3ZlIA0KdGhlIHNldHRpbmcgZ2l2ZW46DQoNCjEuIFdlIGtub3cgdGhhdCB1c2luZyB0 aGlzIHNldHRpbmcgaW5jb3JyZWN0bHkgKHdoaWNoIGNhbiBiZSBkb25lIGZhaXJseSANCmVh c2lseSkgY2FuIGNhdXNlIHNpZ25pZmljYW50IGlzc3Vlcw0KMi4gVGhlcmUncyBhbm90aGVy IHNldHRpbmcgdGhhdCBjYW4gYWNjb21wbGlzaCBzaW1pbGFyIGdvYWxzIHRoYXQncyBtdWNo IA0Kc2FmZXINCjMuIFRoZSBzZXR0aW5nIGl0c2VsZiBpcyBub3Qgd2lkZWx5IHVzZWQNCg0K SXQncyB0aGUgY29tYmluYXRpb24gb2YgYWxsIDMgdGhhdCBsZWQgdG8gbXkgY29uY2x1c2lv bi4gSWYgaXQgd2VyZSBqdXN0IA0KKDEpLCBJJ2QgbGVhbiBtb3JlIHN0cm9uZ2x5IHRvd2Fy ZHMgdHJ5aW5nIHRvIGZpeCBpdCBmaXJzdC4NCg0KPiBIb3dldmVyLCBJIHN1c3BlY3QgdGhh dCB0aGVyZSBhcmVuJ3QgbWFueSBzdWNoIHBlb3BsZSwgYW5kIEkgdGhpbmsgdGhlDQo+IHNl dHRpbmcgaXMgYSBrbHVkZ2UsIHNvIEkgc3VwcG9ydCByZW1vdmluZyBpdC4gTWF5YmUgd2Un bGwgZmluZCBvdXQNCj4gdGhhdCB3ZSBvdWdodCB0byBhZGQgc29tZXRoaW5nIGVsc2UgaW5z dGVhZCwgbGlrZSBhIGxpbWl0ZWQgZGVsaW1pdGVkDQo+IGluIHRpbWUgcmF0aGVyIHRoYW4g aW4gWElEcy4gT3IgbWF5YmUgdGhlIGV4aXN0aW5nIGZhY2lsaXRpZXMgYXJlIGdvb2QNCj4g ZW5vdWdoLiBCdXQgYXMgUGV0ZXIgcmlnaHRseSBzYXlzLCBYSUQgYWdlIGlzIGxpa2VseSBh IHBvb3IgcHJveHkgZm9yDQo+IHdoYXRldmVyIHBlb3BsZSByZWFsbHkgY2FyZSBhYm91dCwg c28gSSBkb24ndCB0aGluayBjb250aW51aW5nIHRvIGhhdmUNCj4gYSBzZXR0aW5nIHRoYXQg d29ya3MgbGlrZSB0aGF0IGlzIGEgZ29vZCBwbGFuLg0KDQpUaGF0IHNlZW1zIGxpa2UgYSBn b29kIGV2ZW50dWFsIG91dGNvbWUuDQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg0KWzFdIA0K aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9iZjQyNzg0Zi00ZDU3LTBh M2QtMWEwNi1mZmFjMWEwOTMxOGMlNDBwb3N0Z3Jlc3FsLm9yZw0KDQo= --------------Yng8auQ5nLFAKyQsouch129h-- --------------TvKbiU6Y5XxbevazZjsRY6Q6 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmQ5WVMFAwAAAAAACgkQ8QSccp8cZSeB mRAAhLK22bOBHPSyz5gwLBFGoydxwHrc87gkz3WA5aQ8qFXOqfULQb9p0pUE+MMctGEMTzXhsK2T gudUN0MoHbjpSxaY/tThhmzviP1qiaPH4szJtjO9YmNXIotE9t4CVNg2BtVP65DyUh+f/Ojwerx3 cAp4/2MRQ7sx+Ar3zDsKB/U0+3FRqGg3+78FEAZgKKHnS9ft40ryLTru9XkGURRzATizFb13fi19 15q4YJM+MqKOilRvN8GEeCFtisQs8tPxiRuY+w03AhnSAPvHqRfFLxhNFpaN71t8I309/9uNVCU9 ASg2yp9NRkH0lFNXixU1b0wp5ye8Vg8xWRPECWEq3A9kVRqWD2nxEZxRc+m778ms+LPLnrG4+agO pkoRsW3iznsl7WIMJ3V98voFhXz01vJUw7xo8FlgXb6cL2IaP3Gcze6BceQKzGmcxENV/CxbQ1Iq jNu2lstAMQHrXo16bbk7hNQ0ALqK/oo5zrM30qVwPndh9AfGFopaelkZ5+uUfrPoj5B/kFYHFj7i IIv4wZNB40Epedugawm/7HEGE7/WxrG05MTHb5+Gf3DMfRH6lXp+D4W4HmnlXpvyX+fFq+jBvDYy prxvrzTAlruAiGQorLv9qesgVjhMGBVGarImFMX1EY4yZeRZRio5bepvIlPFD1kEIc9z6q+mXp42 SGc= =hmp/ -----END PGP SIGNATURE----- --------------TvKbiU6Y5XxbevazZjsRY6Q6--