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 1phMBg-0006YJ-SQ for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Mar 2023 03:09:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phMBd-0006XN-Hk for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Mar 2023 03:09:21 +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 1phMBd-0006XE-3y for pgsql-hackers@lists.postgresql.org; Wed, 29 Mar 2023 03:09:21 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1phMBW-0006Zb-Jl for pgsql-hackers@postgresql.org; Wed, 29 Mar 2023 03:09:20 +0000 Received: by mail-pl1-x636.google.com with SMTP id kc4so13609725plb.10 for ; Tue, 28 Mar 2023 20:09:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680059352; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:from:to:cc:subject :date:message-id:reply-to; bh=h1GRRnmhubijaIlBbE3E/cxzfymoSKhUQuU7H+XKzg0=; b=DRIacCmfCsOKoXuHV8t2Yz4Xa0FZqQGSTO98jdBy/Hr/UbAAv6yS4gpQjejf1vGNV9 IVnkDiJkVcCn9S+AQ9GH3XiKzvEOm7ZG1TzeUJlyIcDV7yVZd2LQ1O7iP/aFdGT9qvFM pnjxDiEtD8J7qiNz651zhL22amkvsnIG3kRske5gsVqvmYzEh4ck2BqiHwiW4cXjM0T2 Vrm6g7IsHJDRJKYRg8/QaYi0yPA/XK/Fkient7AZCorMwHYNYg/xa/RenVE8TWLhpN// RmZHOKHjkaxGZBJD/46zqGEJzQLEBDnplxh9OdQ5NW/sggp8Z4D9IPxZVi0gPDBGABcD pDhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680059352; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=h1GRRnmhubijaIlBbE3E/cxzfymoSKhUQuU7H+XKzg0=; b=2ykfJFFs8RqPoMwvuvsLKH0FDrQ1pLoZjKxscgVZ+huMzT85TFYtNCDDSDFwLlfc1x mCtRNJWCHMbxeRRg1Y/9f1HB3kxHH43myO/5yf9eIAg33KeVTcvazpzE7ouL3rUXFSV7 WSpFLcI2T/MD/vQBS8owogS9pCrnhDjzRDCzzpx7PzUpg6FpbAvc/090GsOFS+Fb2+AP JpNGjYaWSY4ECwzR9lUR01r0fRcQPcndvSXEz/r7EGDupjD660BXF7BWiy+x+mk5TdSE 4BGoIzt1Zixpjn0KFkSozW7jld2UoEPR/vDPjOSsigT6vAV3oh8CsnyFJMP0foGkOSYR QgDw== X-Gm-Message-State: AAQBX9eSMDBNv7Czj+TrqjmJhtVsfW5oMwJo+VYLDLPzpxRGPVRittt7 wvle5d4G9WNQ83yaSDoiXDcW/qOMl1s= X-Google-Smtp-Source: AKy350YQCFMUxcLEbNHu9Lh1P637K6OW/FOjrN6m0vRhBwJzQom8YBopARgcG/B7WpJvcfs53dj5bw== X-Received: by 2002:a17:903:20d4:b0:1a1:c746:7d6f with SMTP id i20-20020a17090320d400b001a1c7467d6fmr13200404plb.53.1680059352142; Tue, 28 Mar 2023 20:09:12 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id b4-20020a170902a9c400b0019f3da8c2a4sm21758263plr.69.2023.03.28.20.09.09 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Tue, 28 Mar 2023 20:09:11 -0700 (PDT) Date: Wed, 29 Mar 2023 12:09:08 +0900 (JST) Message-Id: <20230329.120908.350115307125624430.horikyota.ntt@gmail.com> To: melanieplageman@gmail.com Cc: sawada.mshk@gmail.com, daniel@yesql.se, pgsql-hackers@postgresql.org, andres@anarazel.de, amit.kapila16@gmail.com Subject: Re: Should vacuum process config file reload more often From: Kyotaro Horiguchi In-Reply-To: References: <20230328.172147.1984729741959637354.horikyota.ntt@gmail.com> User-Agent: Mew version 6.8 on Emacs 26.1 Mime-Version: 1.0 Content-Type: Multipart/Mixed; boundary="--Next_Part(Wed_Mar_29_12_09_08_2023_097)--" Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ----Next_Part(Wed_Mar_29_12_09_08_2023_097)-- Content-Type: Text/Plain; charset=utf-8 Content-Transfer-Encoding: base64 QXQgVHVlLCAyOCBNYXIgMjAyMyAyMDozNToyOCAtMDQwMCwgTWVsYW5pZSBQbGFnZW1hbiA8bWVs YW5pZXBsYWdlbWFuQGdtYWlsLmNvbT4gd3JvdGUgaW4gDQo+IE9uIFR1ZSwgTWFyIDI4LCAyMDIz IGF0IDQ6MjHigK9BTSBLeW90YXJvIEhvcmlndWNoaQ0KPiA8aG9yaWt5b3RhLm50dEBnbWFpbC5j b20+IHdyb3RlOg0KPiA+DQo+ID4gQXQgTW9uLCAyNyBNYXIgMjAyMyAxNDoxMjowMyAtMDQwMCwg TWVsYW5pZSBQbGFnZW1hbiA8bWVsYW5pZXBsYWdlbWFuQGdtYWlsLmNvbT4gd3JvdGUgaW4NCj4g PiA+IFNvLCBJJ3ZlIGF0dGFjaGVkIGFuIGFsdGVybmF0ZSB2ZXJzaW9uIG9mIHRoZSBwYXRjaHNl dCB3aGljaCB0YWtlcyB0aGUNCj4gPiA+IGFwcHJvYWNoIG9mIGhhdmluZyBvbmUgY29tbWl0IHdo aWNoIG9ubHkgZW5hYmxlcyBjb3N0LWJhc2VkIGRlbGF5IEdVQw0KPiA+ID4gcmVmcmVzaCBmb3Ig VkFDVVVNIGFuZCBhbm90aGVyIGNvbW1pdCB3aGljaCBlbmFibGVzIGl0IGZvciBhdXRvdmFjdXVt DQo+ID4gPiBhbmQgbWFrZXMgdGhlIGNoYW5nZXMgdG8gYmFsYW5jaW5nIHZhcmlhYmxlcy4NCj4g PiA+DQo+ID4gPiBJIHN0aWxsIHRoaW5rIHRoZSBjb21taXQgd2hpY2ggaGFzIHdvcmtlcnMgdXBk YXRpbmcgdGhlaXIgb3duDQo+ID4gPiB3aV9jb3N0X2RlbGF5IGluIHZhY3V1bV9kZWxheV9wb2lu dCgpIGlzIGEgYml0IHdlaXJkLiBJdCByZWxpZXMgb24gbm8gb25lDQo+ID4gPiBlbHNlIGVtdWxh dGluZyBvdXIgYmFkIGJlaGF2aW9yIGFuZCByZWFkaW5nIGZyb20gd2lfY29zdF9kZWxheSB3aXRo b3V0IGENCj4gPiA+IGxvY2sgYW5kIG9uIG5vIG9uZSBlbHNlIGRlY2lkaW5nIHRvIGV2ZXIgd3Jp dGUgdG8gd2lfY29zdF9kZWxheSAoZXZlbg0KPiA+ID4gdGhvdWdoIGl0IGlzIGluIHNoYXJlZCBt ZW1vcnkgW3RoaXMgaXMgdGhlIHNhbWUgYXMgbWFzdGVyXSkuIEl0IGlzIG9ubHkNCj4gPiA+IHNh ZmUgYmVjYXVzZSBvdXIgcHJvY2VzcyBpcyB0aGUgb25seSBvbmUgKHJpZ2h0IG5vdykgd3JpdGlu ZyB0bw0KPiA+ID4gd2lfY29zdF9kZWxheSwgc28gd2hlbiB3ZSByZWFkIGZyb20gaXQgd2l0aG91 dCBhIGxvY2ssIHdlIGtub3cgaXQgaXNuJ3QNCj4gPiA+IGJlaW5nIHdyaXR0ZW4gdG8uIEFuZCBl dmVyeW9uZSBlbHNlIHRha2VzIGEgbG9jayB3aGVuIHJlYWRpbmcgZnJvbQ0KPiA+ID4gd2lfY29z dF9kZWxheSByaWdodCBub3cuIFNvLCBpdCBzZWVtcy4uLm5vdCBncmVhdC4NCj4gPiA+DQo+ID4g PiBUaGlzIGFwcHJvYWNoIGFsc28gaW50cm9kdWNlcyBhIGZ1bmN0aW9uIHRoYXQgaXMgb25seSBh cm91bmQgZm9yDQo+ID4gPiBvbmUgY29tbWl0IHVudGlsIHRoZSBuZXh0IGNvbW1pdCBvYnNvbGV0 ZXMgaXQsIHdoaWNoIHNlZW1zIGEgYml0IHNpbGx5Lg0KPiA+DQo+ID4gKEknbSBub3Qgc3VyZSB3 aGF0IHRoaXMgcmVmZXJzIHRvLCB0aG91Z2guLikgSSBkb24ndCB0aGluayBpdCdzIHNpbGx5DQo+ ID4gaWYgYSBsYXRlciBwYXRjaCByZW1vdmVzIHNvbWV0aGluZyB0aGF0IHRoZSBwcmVjZWRpbmcg cGF0Y2hlcw0KPiA+IGludHJvZGN1ZWQsIGFzIGxvbmcgYXMgdGhhdCBjb250cmlidXRlcyB0byBy ZWFkYWJpbGl0eS4gIFVudGltYXRlbHksDQo+ID4gdGhleSB3aWxsIGJlIG1lcmdlZCB0b2dldGhl ciBvbiBjb21taXR0aW5nLg0KPiANCj4gSSB3YXMgdW5kZXIgdGhlIGltcHJlc3Npb24gdGhhdCBy ZXZpZXdlcnMgdGhvdWdodCBjb25maWcgcmVsb2FkIGFuZA0KPiB3b3JrZXIgYmFsYW5jZSBjaGFu Z2VzIHNob3VsZCBiZSBjb21taXR0ZWQgaW4gc2VwYXJhdGUgY29tbWl0cy4NCj4gDQo+IEVpdGhl ciB3YXksIHRoZSBlcGhlbWVyYWwgZnVuY3Rpb24gaXMgbm90IG15IHByaW1hcnkgY29uY2Vybi4g SSBmZWx0DQo+IG1vcmUgdW5jb21mb3J0YWJsZSB3aXRoIGluY3JlYXNpbmcgaG93IG9mdGVuIHdl IHVwZGF0ZSBhIGRvdWJsZSBpbg0KPiBzaGFyZWQgbWVtb3J5IHdoaWNoIGlzIHJlYWQgd2l0aG91 dCBhY3F1aXJpbmcgYSBsb2NrLg0KPiANCj4gPiA+IEJhc2ljYWxseSwgSSB0aGluayBpdCBpcyBw cm9iYWJseSBiZXR0ZXIgdG8ganVzdCBoYXZlIG9uZSBjb21taXQNCj4gPiA+IGVuYWJsaW5nIGd1 YyByZWZyZXNoIGZvciBWQUNVVU0gYW5kIHRoZW4gYW5vdGhlciB3aGljaCBjb3JyZWN0bHkNCj4g PiA+IGltcGxlbWVudHMgd2hhdCBpcyBuZWVkZWQgZm9yIGF1dG92YWN1dW0gdG8gZG8gdGhlIHNh bWUuDQo+ID4gPiBBdHRhY2hlZCB2OSBkb2VzIHRoaXMuDQo+ID4gPg0KPiA+ID4gSSd2ZSBwcm92 aWRlZCBib3RoIGNvbXBsZXRlIHZlcnNpb25zIG9mIGJvdGggYXBwcm9hY2hlcyAodjkgYW5kIHY4 KS4NCj4gPg0KPiA+IEkgdG9vayBhIGxvb2sgYXQgdjkgYW5kIGhhdmUgYSBmZXcgY29tbWVudHMu DQo+ID4NCj4gPiAwMDAxOg0KPiA+DQo+ID4gSSBkb24ndCBiZWxpZXZlIGl0IGlzIG5lY2Vzc2Fy eSwgYXMgbWVudGlvbmVkIGluIHRoZSBjb21taXQNCj4gPiBtZXNzYWdlLiBJdCBhcHBlcmFzIHRo YXQgd2UgYXJlIHJlc2V0dGluZyBpdCBhdCB0aGUgYXBwcm9wcmlhdGUgdGltZXMuDQo+IA0KPiBW YWN1dW1Db3N0QmFsYW5jZSBtdXN0IGJlIHplcm9lZCBvdXQgd2hlbiB3ZSBkaXNhYmxlIHZhY3V1 bSBjb3N0Lg0KPiBQcmV2aW91c2x5LCB3ZSBkaWQgbm90IHJlZW5hYmxlIFZhY3V1bUNvc3RBY3Rp dmUgb25jZSBpdCB3YXMgZGlzYWJsZWQsDQo+IGJ1dCBub3cgdGhhdCB3ZSBkbywgSSB0aGluayBp dCBpcyBnb29kIHByYWN0aWNlIHRvIGFsd2F5cyB6ZXJvIG91dA0KPiBWYWN1dW1Db3N0QmFsYW5j ZSB3aGVuIHdlIGRpc2FibGUgdmFjdXVtIGNvc3QuIEkgd2lsbCBzcXVhc2ggdGhpcyBjb21taXQN Cj4gaW50byB0aGUgb25lIGludHJvZHVjaW5nIFZhY3V1bUNvc3RJbmFjdGl2ZSwgdGhvdWdoLg0K DQo+ID4NCj4gPiAwMDAyOg0KPiA+DQo+ID4gSSBmZWx0IGEgYml0IHVuZWFzeSBvbiB0aGlzLiBJ dCBzZWVtcyBzb21ld2hhdCBjb21wbGV4IChhbmQgbWFrZXMgdGhlDQo+ID4gc3VjY2VlZGluZyBw YXRjaGVzIGNvbXBsZXgpLA0KPiANCj4gRXZlbiBpZiB3ZSBpbnRyb2R1Y2VkIGEgc2Vjb25kIGds b2JhbCB2YXJpYWJsZSB0byBpbmRpY2F0ZSB0aGF0IGZhaWxzYWZlDQo+IG1vZGUgaGFzIGJlZW4g ZW5nYWdlZCwgd2Ugd291bGQgc3RpbGwgcmVxdWlyZSB0aGUgYWRkaXRpb25hbCBjaGVja3MNCj4g b2YgVmFjdXVtQ29zdEluYWN0aXZlLg0KPg0KPiA+IGhhcyBjb25mdXNpbmcgbmFtZXMsDQo+IA0K PiBJIHdvdWxkIGJlIGhhcHB5IHRvIHJlbmFtZSB0aGUgdmFsdWVzIG9mIHRoZSBlbnVtIHRvIG1h a2UgdGhlbSBsZXNzDQo+IGNvbmZ1c2luZy4gQXJlIHlvdSB0aGlua2luZyAiZm9yY2UiIGluc3Rl YWQgb2YgImxvY2tlZCI/DQo+IG1heWJlOg0KPiBWQUNVVU1fQ09TVF9GT1JDRV9JTkFDVElWRSBh bmQNCj4gVkFDVVVNX0NPU1RfSU5BQ1RJVkUNCj4gPw0KPiANCj4gPiBhbmQgZG9lc24ndCBzZWVt IGxpa2Ugc2VsZi1jb250YWluZWQuDQo+IA0KPiBCeSBjaGFuZ2luZyB0aGUgdmFyaWFibGUgZnJv bSBWYWN1dW1Db3N0QWN0aXZlIHRvIFZhY3V1bUNvc3RJbmFjdGl2ZSwgSQ0KPiBoYXZlIGtlcHQg YWxsIG5vbi12YWN1dW0gY29kZSBmcm9tIGhhdmluZyB0byBkaXN0aW5ndWlzaCBiZXR3ZWVuIGl0 DQo+IGJlaW5nIGluYWN0aXZlIGR1ZSB0byBmYWlsc2FmZSBtb2RlIG9yIGR1ZSB0byB1c2VyIHNl dHRpbmdzLg0KDQpNeSBjb25jZXJuIGlzIHRoYXQgVmFjdXVtQ29zdEFjdGl2ZSBpcyBsb2dpYy1p bnZlcnRlZCBhbmQgdHVybmVkIGludG8NCmEgdGVybmFyeSB2YXJpYWJsZSBpbiBhIHN1YnRsZSB3 YXkuIFRoZSBleHByZXNzaW9uDQoiIVZhY3V1bUNvc3RJbmFjdGl2ZSIgaXMgcXVpdGUgY29uZnVz aW5nLiAoSSBzb21ldGltZXMgZmVlbCB0aGUgc2FtZQ0Kd2F5IGFib3V0ICIhWExvZ1JlY1B0cklz SW52YWxpZChsc24pIiwgYW5kIEkgYmVsaWV2ZSBtb3N0IHBlb3BsZSB3cml0ZQ0KaXQgd2l0aCBh bm90aGVyIG1hY3JvIGxpa2UgImxzbiAhPSBJbnZhbGlkWExvZ3JlY1B0ciIpLiBBZGRpdGlvbmFs bHksDQp0aGUgY29uc3RyYWludCBpbiB0aGlzIHBhdGNoIHdpbGwgYmUgaW1wbGVtZW50ZWQgYXMg b3BlbiBjb2RlLiAgU28gSQ0Kd2FudGVkIHRvIHN1Z2dlc3Qgc29tZXRoaW5nIGxpa2UgdGhlIGF0 dGFjaGVkLiBUaGUgbWFpbiBpZGVhIGlzIHRvIHVzZQ0KYSB3cmFwcGVyIGZ1bmN0aW9uIHRvIGVu Zm9yY2UgdGhlIHJlc3RyaWN0aW9uLCBhbmQgYnkgZG9pbmcgc28sIHdlDQplbGltaW5hdGVkIHRo ZSBuZWVkIHRvIG1ha2UgdGhlIHZhcmlhYmxlIGludG8gYSB0ZXJuYXJ5IHdpdGhvdXQgYSBnb29k DQpyZWFzb24uDQoNCj4gPiBJIHRoaW5rIGl0J2QgYmUgc2ltcGxlciB0byBhZGQgYSBnbG9iYWwg Ym9vbGVhbiAobWF5YmUNCj4gPiBWYWN1dW1Db3N0QWN0aXZlRm9yY2VEaXNhYmxlIG9yIHN1Y2gp IHRoYXQgZm9yY2VzIFZhY3V1bUNvc3RBY3RpdmUgdG8NCj4gPiBiZSBmYWxzZSBhbmQgc2V0IFZh Y3V1bUNvc3RBY3RpdmUgdXNpbmcgYSBzZXR0ZXIgZnVuY3Rpb24gdGhhdCBmb2xsb3dzDQo+ID4g dGhlIGJvb2xlYW4uDQo+IA0KPiBJIHRoaW5rIG1haW50YWluaW5nIGFuIGFkZGl0aW9uYWwgZ2xv YmFsIHZhcmlhYmxlIGlzIG1vcmUgYnJpdHRsZSB0aGFuDQo+IGluY2x1ZGluZyB0aGUgaW5mb3Jt YXRpb24gaW4gYSBzaW5nbGUgdmFyaWFibGUuDQo+IA0KPiA+IDAwMDM6DQo+ID4NCj4gPiArICAg ICAgICAqIFJlbG9hZCB0aGUgY29uZmlndXJhdGlvbiBmaWxlIGlmIHJlcXVlc3RlZC4gVGhpcyBh bGxvd3MgY2hhbmdlcyB0bw0KPiA+ICsgICAgICAgICogdmFjdXVtX2Nvc3RfbGltaXQgYW5kIHZh Y3V1bV9jb3N0X2RlbGF5IHRvIHRha2UgZWZmZWN0IHdoaWxlIGEgdGFibGUgaXMNCj4gPiArICAg ICAgICAqIGJlaW5nIHZhY3V1bWVkIG9yIGFuYWx5emVkLiBBbmFseXplIHNob3VsZCBub3QgcmVs b2FkIGNvbmZpZ3VyYXRpb24NCj4gPiArICAgICAgICAqIGZpbGUgaWYgaXQgaXMgaW4gYW4gb3V0 ZXIgdHJhbnNhY3Rpb24sIGFzIEdVQyB2YWx1ZXMgc2hvdWxkbid0IGJlDQo+ID4gKyAgICAgICAg KiBhbGxvd2VkIHRvIHJlZmVyIHRvIHNvbWUgdW5jb21taXR0ZWQgc3RhdGUgKGUuZy4gZGF0YWJh c2Ugb2JqZWN0cw0KPiA+ICsgICAgICAgICogY3JlYXRlZCBpbiB0aGlzIHRyYW5zYWN0aW9uKS4N Cj4gPg0KPiA+IEknbSBub3Qgc3VyZSBHVUMgcmVsb2FkIGlzIG9yIHNob3VsZCBiZSByZWxhdGVk IHRvIHRyYW5zYWN0aW9ucy4gRm9yDQo+ID4gaW5zdGFuY2UsIHdvcmtfbWVtIGNhbiBiZSBjaGFu Z2VkIGJ5IGEgcmVsb2FkIGR1cmluZyBhIHRyYW5zYWN0aW9uDQo+ID4gdW5sZXNzIGl0IGhhcyBi ZWVuIHNldCBpbiB0aGUgY3VycmVudCB0cmFuc2FjdGlvbi4gSSBkb24ndCB0aGluayB3ZQ0KPiA+ IG5lZWQgdG8gZGVsaWJlcmF0ZWx5IHN1cHByZXNzIGNoYW5nZXMgaW4gdmFyaWFibGVzIGNhdXNl ZCBieSByZWFsb2RzDQo+ID4gZHVyaW5nIHRyYW5zYWN0aW9ucyBvbmx5IGZvciBhbmFsenllLiBJ ZiBhbmFseXplIGRvZXNuJ3QgbGlrZSBjaGFuZ2VzDQo+ID4gdG8gY2VydGFpbiBHVUMgdmFyaWFi bGVzLCB0aGVpciB2YWx1ZXMgc2hvdWxkIGJlIHNuYXBzaG90dGVkIGJlZm9yZQ0KPiA+IHN0YXJ0 aW5nIHRoZSBwcm9jZXNzLg0KPiANCj4gQ3VycmVudGx5LCB3ZSBvbmx5IHJlbG9hZCB0aGUgY29u ZmlnIGZpbGUgaW4gdG9wLWxldmVsIHN0YXRlbWVudHMuIFdlDQo+IGRvbid0IHJlbG9hZCB0aGUg Y29uZmlndXJhdGlvbiBmaWxlIGZyb20gd2l0aGluIGEgbmVzdGVkIHRyYW5zYWN0aW9uDQo+IGNv bW1hbmQuIEJFR0lOIHN0YXJ0cyBhIHRyYW5zYWN0aW9uIGJ1dCBub3QgYSB0cmFuc2FjdGlvbiBj b21tYW5kLiBTbw0KPiBCRUdJTjsgQU5BTFlaRTsgcHJvYmFibHkgd291bGRuJ3QgdmlvbGF0ZSB0 aGlzIHJ1bGUuIEJ1dCBpdCBpcyBzaW1wbGVyDQo+IHRvIGp1c3QgZm9yYmlkIHJlbG9hZGluZyB3 aGVuIGl0IGlzIG5vdCBhIHRvcC1sZXZlbCB0cmFuc2FjdGlvbiBjb21tYW5kLg0KPiBJIGhhdmUg dXBkYXRlZCB0aGUgY29tbWVudCB0byByZWZsZWN0IHRoaXMuDQoNCkkgZmVlbCBpdCdzIGEgYml0 IGZyYWdpbGUuIFdlIG1heSBub3QgYmUgYWJsZSB0byBtYW5hZ2UgdGhlIHJlbG9hZA0KdGltZWlu ZyBwZXJmZWN0bHkuIEkgdGhpbmsgd2UgbWlnaHQgYWNjaWRlbnRhbGx5IGFkZCBhIHJlbG9hZA0K dGltaW5nLiBJbiB0aGF0IGNhc2UsIHRoZSBhc3N1bXB0aW9uIGNvdWxkIGJyZWFrLiBJbiBtb3N0 IGNhc2VzLCBJDQp0aGluayB3ZSB1c2Ugc25hcHNob3R0aW5nIGluIHZhcmlvdXMgd2F5cyB0byBh dm9pZCB1bmludGVuZGVkIHZhcmlhYmxlDQpjaGFuZ2VzLiAoQW5kIEkgYmVpbGlldmUgdGhlIGFu YWx5emUgY29kZSBhbHNvIGRvZXMgdGhhdC4pDQoNCj4gPiArICAgICAgICAgICAgICAgLyogVGhl cmUgaXMgYXQgbGVhc3QgMSBhdXRvdmFjIHdvcmtlciAodGhpcyB3b3JrZXIpLiAqLw0KPiA+ICsg ICAgICAgICAgICAgICBpbnQgICAgICAgICAgICAgICAgICAgICBud29ya2Vyc19mb3JfYmFsYW5j ZSA9IE1heChwZ19hdG9taWNfcmVhZF91MzIoDQo+ID4gKyAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICZBdXRvVmFjdXVtU2htZW0t PmF2X253b3JrZXJzX2Zvcl9iYWxhbmNlKSwgMSk7DQo+ID4NCj4gPiBJIHRoaW5rIGl0ICptdXN0 KiBiZSBncmVhdGVyIHRoYW4gMC4gSG93ZXZlciwgdG8gYmVnaW4gd2l0aCwgSSBkb24ndA0KPiA+ IHRoaW5rIHdlIG5lZWQgdGhhdCB2YXJpYWJsZSB0byBiZSBzaGFyZWQuIEkgZG9uJ3QgYmVsaWV2 ZSBpdCBtYXR0ZXJzDQo+ID4gaWYgd2UgY291bnQgaW52b2x2ZWQgd29ya2VycyBldmVyeSB0aW1l IHdlIGNhbGN1bGF0ZSB0aGUgZGVsYXkuDQo+IA0KPiBXZSBhcmUgbm90IGNhbGN1bGF0aW5nIHRo ZSBkZWxheSBidXQgdGhlIGNvc3QgbGltaXQuIFRoZSBjb3N0IGxpbWl0IG11c3QNCg0KQWgsIHJp Z2h0LCBpdCdzIGxpbWl0LCBidXQgbXkgbWFpbiBwb2ludCBzdGlsbCBzdGFuZHMuDQoNCj4gYmUg YmFsYW5jZWQgYWNyb3NzIGFsbCBvZiB0aGUgd29ya2VycyBjdXJyZW50bHkgYWN0aXZlbHkgdmFj dXVtaW5nDQo+IHRhYmxlcyB3aXRob3V0IGNvc3QtcmVsYXRlZCB0YWJsZSBvcHRpb25zLg0KDQpU aGUgcHVycG9zZSBvZiB0aGUgb2xkIGF1dG92YWNfYmFsYW5jZV9jb3N0KCkgaXMgdG8gZGlzdHJp YnV0ZSB0aGUNCmNvc3QgYW1vbmcgYWxsIGludm9sdmVkIHRhYmxlcywgcHJvcG9ydGlvbmFsbHkg YmFzZWQgb24gZWFjaCB3b3JrZXIncw0KY29zdCBzcGVjaWZpY2F0aW9uLiAgQWRqdXN0aW5nIHRo ZSBsaW1pdCBqdXN0IGZvciB0YWJsZXMgYWZmZWN0ZWQgYnkNCnJlbG9hZHMgZGlzcnVwdHMgdGhl IGNvc3QgYmFsYW5jZS4NCg0KPiA+IElmIEknbSBub3QgbWlzc2luZyBhbnl0aGluZywgdGhpcyBm dW5jdGlvbiBkb2VzIHNvbWV0aGluZyBxdWl0ZQ0KPiA+IGRpZmZlcmVudCBmcm9tIHRoZSBvcmln aW5hbCBhdXRvdmFjX2JhbGFuY2VfY29zdCgpLiAgVGhlIG9yaWdpbmFsDQo+ID4gZnVuY3Rpb24g ZGlzdHJpYnV0ZXMgdGhlIHRvdGFsIGNvc3QgYmFzZWQgb24gdGhlIEdVQyB2YXJpYWJsZXMgYW1v bmcNCj4gPiB3b3JrZXJzIHByb3BvcnRpb25hbGx5IGFjY29yZGluZyB0byBlYWNoIHdvcmtlcidz IGNvc3QNCj4gPiBwYXJhbWV0ZXJzLiBIb3dldndlciwgdGhpcyBmdW5jdGlvbiBkaXN0cmlidXRl cyB0aGUgdG90YWwgY29zdA0KPiA+IGVxdWFsbHkuDQo+IA0KPiBZZXMsIGFzIEkgbWVudGlvbmVk IGluIHRoZSBjb21taXQgbWVzc2FnZSwgYmVjYXVzZSBhbGwgdGhlIHdvcmtlcnMgbm93DQo+IGhh dmUgbm8gcmVhc29uIHRvIGhhdmUgZGlmZmVyZW50IGNvc3QgcGFyYW1ldGVycyAoZHVlIHRvIHJl bG9hZGluZyB0aGUNCj4gY29uZmlnIGZpbGUgb24gYWxtb3N0IGV2ZXJ5IHBhZ2UpLCB0aGVyZSBp cyBubyByZWFzb24gdG8gdXNlIHJhdGlvcy4NCj4gV29ya2VycyB2YWN1dW1pbmcgYSB0YWJsZSB3 aXRoIG5vIGNvc3QtcmVsYXRlZCB0YWJsZSBvcHRpb25zIHNpbXBseSBuZWVkDQo+IHRvIGRpdmlk ZSB0aGUgbGltaXQgZXF1YWxseSBhbW9uZ3N0IHRoZW1zZWx2ZXMgYmVjYXVzZSB0aGV5IGFsbCB3 aWxsDQo+IGhhdmUgdGhlIHNhbWUgbGltaXQgYW5kIGRlbGF5IHZhbHVlcy4NCg0KSSdtIG5vdCBz dXJlIGFib3V0IHRoZSBhc3N1bXB0aW9uIGluIHRoZSBjb21taXQgbWVzc2FnZS4gRm9yIGluc3Rh bmNlLA0KaWYgdGhlIHRvdGFsIGNvc3QgbGltaXQgZHJvcHMgc2lnbmlmaWNhbnRseSwgaXQncyBw b3NzaWJsZSB0aGF0IHRoZQ0Kd29ya2VycyBsZWZ0IG91dCBvZiB0aGlzIGNhbGN1bGF0aW9uIG1p Z2h0IGVuZCB1cCB1c2luZyBhbGwgdGhlDQpyZWR1Y2VkIGNvc3QuIFdvdWxkbid0IHRoaXMgaW1w bHkgdGhhdCBhbGwgd29ya2VycyBzaG91bGQgcmVjb21wdXRlDQp0aGVpciBpbmRpdmlkdWFsIGxp bWl0cz8NCg0KPiA+DQo+ID4gKyAgICAgICAgICAgICAgIGludCAgICAgICAgICAgICAgICAgICAg IHZhY19jb3N0X2xpbWl0ID0gYXV0b3ZhY3V1bV92YWNfY29zdF9saW1pdCA+IDAgPw0KPiA+ICsg ICAgICAgICAgICAgICBhdXRvdmFjdXVtX3ZhY19jb3N0X2xpbWl0IDogVmFjdXVtQ29zdExpbWl0 Ow0KPiA+IC4uLg0KPiA+ICsgICAgICAgICAgICAgICBpbnQgICAgICAgICAgICAgICAgICAgICBi YWxhbmNlZF9jb3N0X2xpbWl0ID0gdmFjX2Nvc3RfbGltaXQgLyBud29ya2Vyc19mb3JfYmFsYW5j ZTsNCj4gPiAuLi4NCj4gPiArICAgICAgICAgICAgICAgVmFjdXVtQ29zdExpbWl0ID0gTWF4KE1p bihiYWxhbmNlZF9jb3N0X2xpbWl0LCB2YWNfY29zdF9saW1pdCksIDEpOw0KPiA+ICAgICAgICAg fQ0KPiA+DQo+ID4gVGhpcyBzZWVtcyB0byByZXBlYXRlZGx5IGRpdmlkZSBWYWN1dW1Db3N0TGlt aXQgYnkNCj4gPiBud29ya2Vyc19mb3JfYmFsYW5jZS4gSSdtIG5vdCBzdXJlLCBidXQgdGhpcyBm dW5jdGlvbiBtaWdodCBvbmx5IGJlDQo+ID4gY2FsbGVkIGFmdGVyIGEgcmVsb2FkLiBJZiB0aGF0 J3MgdGhlIGNhc2UsIEkgZG9uJ3QgdGhpbmsgaXQncyBzYWZlDQo+ID4gY29kaW5nLCBldmVuIGlm IGl0IHdvcmtzLg0KPiANCj4gR29vZCBwb2ludCBhYm91dCByZXBlYXRlZGx5IGRpdmlkaW5nIFZh Y3V1bUNvc3RMaW1pdCBieQ0KPiBud29ya2Vyc19mb3JfYmFsYW5jZS4gSSd2ZSBhZGRlZCBhIHZh cmlhYmxlIHRvIGtlZXAgdHJhY2sgb2YgdGhlIGJhc2UNCj4gY29zdCBsaW1pdCBhbmQgc2VwYXJh dGVkIHRoZSBmdW5jdGlvbmFsaXR5IG9mIHVwZGF0aW5nIHRoZSBsaW1pdCBpbnRvDQo+IHR3byBw YXJ0cyAtLSBvbmUgQXV0b1ZhY3V1bVVwZGF0ZUxpbWl0KCkgd2hpY2ggaXMgb25seSBtZWFudCB0 byBiZQ0KPiBjYWxsZWQgYWZ0ZXIgcmVsb2FkIGFuZCByZWZlcmVuY2VzIFZhY3V1bUNvc3RMaW1p dCB0byBzZXQgdGhlDQo+IGF2X2Jhc2VfY29zdF9saW1pdCBhbmQgYW5vdGhlciwgQXV0b1ZhY3V1 bUJhbGFuY2VMaW1pdCgpLCB3aGljaCBvbmx5DQo+IG92ZXJyaWRlcyBWYWN1dW1Db3N0TGltaXQg YnV0IHVzZXMgYXZfYmFzZV9jb3N0X2xpbWl0Lg0KDQpTb3JyeSwgYnV0IHdpbGwgY2hlY2sgdGhp cyBsYXRlci4NCg0KPiBJJ3ZlIG5vdGVkIGluIHRoZSBjb21tZW50cyB0aGF0IEF1dG9WYWN1dW1C YWxhbmNlTGltaXQoKSBzaG91bGQgYmUNCj4gY2FsbGVkIHRvIGFkanVzdCB0byBhIHBvdGVudGlh bCBjaGFuZ2UgaW4gbndvcmtlcnNfZm9yX2JhbGFuY2UNCj4gKGN1cnJlbnRseSBldmVyeSB0aW1l IGFmdGVyIHdlIHNsZWVwIGluIHZhY3V1bV9kZWxheV9wb2ludCgpKSBhbmQNCj4gQXV0b1ZhY3V1 bVVwZGF0ZUxpbWl0KCkgc2hvdWxkIG9ubHkgYmUgY2FsbGVkIG9uY2UgYWZ0ZXIgYSBjb25maWcN Cj4gcmVsb2FkLCBhcyBpdCByZWZlcmVuY2VzIFZhY3V1bUNvc3RMaW1pdC4NCj4gDQo+IEkgd2ls bCBub3RlIHRoYXQgdGhpcyBwcm9ibGVtIGFsc28gZXhpc3RzIGluIG1hc3RlciwgYXMNCj4gYXV0 b3ZhY19iYWxhbmNlX2Nvc3QgcmVmZXJlbmNlcyBWYWN1dW1Db3N0TGltaXQgaW4gb3JkZXIgdG8g c2V0IHdvcmtlcg0KPiBjb3N0IGxpbWl0cyBhbmQgdGhlbiBBdXRvVmFjdXVtVXBkYXRlRGVsYXko KSBvdmVycmlkZXMgVmFjdXVtQ29zdExpbWl0DQo+IHdpdGggdGhlIHZhbHVlIGNhbGN1bGF0ZWQg aW4gYXV0b3ZhY19iYWxhbmNlX2Nvc3QoKSBmcm9tDQo+IFZhY3V1bUNvc3RMaW1pdC4NCj4gDQo+ IHYxMCBhdHRhY2hlZCB3aXRoIG1lbnRpb25lZCB1cGRhdGVzLg0KDQotLSANCkt5b3Rhcm8gSG9y aWd1Y2hpDQpOVFQgT3BlbiBTb3VyY2UgU29mdHdhcmUgQ2VudGVyDQo= ----Next_Part(Wed_Mar_29_12_09_08_2023_097)-- Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="allow_disabling_vacuum_cost_active_change.txt" diff --git a/src/backend/access/heap/vacuumlazy.c b/src/backend/access/heap/vacuumlazy.c index 8f14cf85f3..343500dbe2 100644 --- a/src/backend/access/heap/vacuumlazy.c +++ b/src/backend/access/heap/vacuumlazy.c @@ -2637,7 +2637,8 @@ lazy_check_wraparound_failsafe(LVRelState *vacrel) "You might also need to consider other ways for VACUUM to keep up with the allocation of transaction IDs."))); /* Stop applying cost limits from this point on */ - VacuumCostActive = false; + VacuumCostActiveForceDisable = true; + SetVacuumCostActive(false); VacuumCostBalance = 0; return true; diff --git a/src/backend/commands/vacuum.c b/src/backend/commands/vacuum.c index c54360a6a0..f78219bd1e 100644 --- a/src/backend/commands/vacuum.c +++ b/src/backend/commands/vacuum.c @@ -491,7 +491,7 @@ vacuum(List *relations, VacuumParams *params, ListCell *cur; in_vacuum = true; - VacuumCostActive = (VacuumCostDelay > 0); + SetVacuumCostActive(VacuumCostDelay > 0); VacuumCostBalance = 0; VacuumPageHit = 0; VacuumPageMiss = 0; @@ -549,7 +549,7 @@ vacuum(List *relations, VacuumParams *params, PG_FINALLY(); { in_vacuum = false; - VacuumCostActive = false; + SetVacuumCostActive(false); } PG_END_TRY(); diff --git a/src/backend/commands/vacuumparallel.c b/src/backend/commands/vacuumparallel.c index bcd40c80a1..47e0c2c354 100644 --- a/src/backend/commands/vacuumparallel.c +++ b/src/backend/commands/vacuumparallel.c @@ -990,7 +990,7 @@ parallel_vacuum_main(dsm_segment *seg, shm_toc *toc) false); /* Set cost-based vacuum delay */ - VacuumCostActive = (VacuumCostDelay > 0); + SetVacuumCostActive(VacuumCostDelay > 0); VacuumCostBalance = 0; VacuumPageHit = 0; VacuumPageMiss = 0; diff --git a/src/backend/utils/init/globals.c b/src/backend/utils/init/globals.c index 1b1d814254..1191a39618 100644 --- a/src/backend/utils/init/globals.c +++ b/src/backend/utils/init/globals.c @@ -150,4 +150,13 @@ int64 VacuumPageMiss = 0; int64 VacuumPageDirty = 0; int VacuumCostBalance = 0; /* working state for vacuum */ -bool VacuumCostActive = false; +bool VacuumCostActive = false; /* should be set using SetVacuumCostActive() */ +bool VacuumCostActiveForceDisable = false; + +/* Set VacuumCostActive following VacuumCostActiveForceDisable */ +void +SetVacuumCostActive(bool value) +{ + VacuumCostActive = value && !VacuumCostActiveForceDisable; +} + diff --git a/src/include/miscadmin.h b/src/include/miscadmin.h index 06a86f9ac1..97fa3896c0 100644 --- a/src/include/miscadmin.h +++ b/src/include/miscadmin.h @@ -275,7 +275,9 @@ extern PGDLLIMPORT int64 VacuumPageDirty; extern PGDLLIMPORT int VacuumCostBalance; extern PGDLLIMPORT bool VacuumCostActive; +extern PGDLLIMPORT bool VacuumCostActiveForceDisable; +extern void SetVacuumCostActive(bool value); /* in tcop/postgres.c */ ----Next_Part(Wed_Mar_29_12_09_08_2023_097)----