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 1q06q1-0002hz-Ta for pgsql-admin@arkaria.postgresql.org; Fri, 19 May 2023 20:36:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q06q0-0000gQ-Bi for pgsql-admin@arkaria.postgresql.org; Fri, 19 May 2023 20:36:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q06pz-0000gG-Rw for pgsql-admin@lists.postgresql.org; Fri, 19 May 2023 20:36:32 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q06pt-000jam-Vc for pgsql-admin@lists.postgresql.org; Fri, 19 May 2023 20:36:30 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-953343581a4so559575266b.3 for ; Fri, 19 May 2023 13:36:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1684528584; x=1687120584; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=WbBhDeMLjjspkNWtF7swbHLOj9GsF7Qdk0WECMhRrAw=; b=OSxohf1CtlQk3bE2XyiXYy2nu5vvlprRJjYEo4CMOey0dw9DFDS+Nl6GjqiAuxJR7u D9/IxI/9z/U8hvM8K4d/YSrKUtwVHdb2PeZrofc+vc6Y9AVV10tpIAWd/a5FWFehaQ+b dbhvLqMKpS2VfGQF74OUktnrk6eYm5BtrHcfFlyWRiLZHfx2bhu5ZLtYgaeuzR5z3rSp 0RjAJmTEW0iuAhqUGcOOLQPzOWPmv2lZYkOW6Xy9Z6MHKYLd/Fxm9fBgARjcgS7M4gZe +M+7dMRLzG19yOUyMIMbQPrpXPICF/aPURFn53s3VoAXEIqUk0ilDjJI5/6stm3IXS+C Q2+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684528584; x=1687120584; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=WbBhDeMLjjspkNWtF7swbHLOj9GsF7Qdk0WECMhRrAw=; b=Sxcr0v4d34NiXvTOONkWX0UPD5qfa7fTIaWi8TKMeev//zhfYNLRLkVM5ZaFQmj6ij QVU5zZhcbg3i/qDtag8AsjcdJcJemmQ8kEYILbl6HDT5q8eqL16ungJIwrHy/30EK7gV pLxPgvvHvhdqOf51k3puoaAdrnkeFbbckwCzw73W9ONRAnqH40v2UP+89NUBRDQ0dRJX G1fYNjAJFxXLH+57ntaUyxE2zzNFxMOUiy4GUonGBdAoWDoB1S1vTg9/u7mMnvhmrH/7 CEm7G3CXoNKHwqwchi6ACPtTSjmzx//w8UkkV0mGu2AVO47wj9fZFQ9Fh0pOaA3YV4QQ hPYw== X-Gm-Message-State: AC+VfDxvfRl3xwVO988pJcd/uxtifw+HWwisx6hI7GChQkWdum7R+BGw llbJo2pxiVkKijxmib1skggWMw== X-Google-Smtp-Source: ACHHUZ5mKEVcov2b2lmuiwm6Zp1sTXr0jk71NvzG55z02UlxxFTlAxClT/FqVADcnrzFzl/AawX3Lw== X-Received: by 2002:a17:906:9b86:b0:94e:54ec:1a10 with SMTP id dd6-20020a1709069b8600b0094e54ec1a10mr3580660ejc.29.1684528584242; Fri, 19 May 2023 13:36:24 -0700 (PDT) Received: from localhost.localdomain (62-47-150-178.adsl.highway.telekom.at. [62.47.150.178]) by smtp.gmail.com with ESMTPSA id os19-20020a170906af7300b0094f58a85bc5sm16937ejb.180.2023.05.19.13.36.23 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 19 May 2023 13:36:23 -0700 (PDT) Message-ID: Subject: Re: Vacuum Tuning Question From: Laurenz Albe To: Murthy Nunna , "pgsql-admin@lists.postgresql.org" Date: Fri, 19 May 2023 22:36:23 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpLCAyMDIzLTA1LTE5IGF0IDE1OjM1ICswMDAwLCBNdXJ0aHkgTnVubmEgd3JvdGU6Cj4g Rm9sbG93aW5nIGFyZSB0aGUgc2V0dGluZ3MgSSBoYXZlLiBJIGFtIHdvbmRlcmluZyBpZiB0aGVy ZSBpcyBhIHdheSBhdXRvdmFjdXVtwqAgY2FuIGtlZXAgdGhlIGFib3ZlCj4g4oCcZGF0ZnJvemVu eGlk4oCdIGxvdyBhbmQgbm90IGtlZXAgaW5jcmVhc2luZy4gVGhhbmsgeW91IGFoZWFkIHRpbWUg Zm9yIHJlYWRpbmcgbXkgcG9zdC4KPiDCoAo+IHBvc3RncmVzPSMgc2VsZWN0IG5hbWUsIHNldHRp bmcsIHVuaXQgZnJvbSBwZ19zZXR0aW5ncyB3aGVyZSBuYW1lIGxpa2UgJyVhdXRvdmFjdXVtJSc7 Cj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgbmFtZcKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqAgfMKgIHNldHRpbmfCoMKgIHwgdW5pdAo+IC0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tCj4gYXV0b3ZhY3V1 bcKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8 IG9uwqDCoMKgwqDCoMKgwqDCoCB8Cj4gYXV0b3ZhY3V1bV9hbmFseXplX3NjYWxlX2ZhY3RvcsKg wqDCoMKgwqDCoCB8IDAuMcKgwqDCoMKgwqDCoMKgIHwKPiBhdXRvdmFjdXVtX2FuYWx5emVfdGhy ZXNob2xkwqDCoMKgwqDCoMKgwqDCoMKgIHwgNTAwMMKgwqDCoMKgwqDCoCB8Cj4gYXV0b3ZhY3V1 bV9mcmVlemVfbWF4X2FnZcKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8IDE1MDAwMDAwMDAgfAo+ IGF1dG92YWN1dW1fbWF4X3dvcmtlcnPCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCA1 wqDCoMKgwqDCoMKgwqDCoMKgIHwKPiBhdXRvdmFjdXVtX211bHRpeGFjdF9mcmVlemVfbWF4X2Fn ZcKgwqAgfCA0MDAwMDAwMDDCoCB8Cj4gYXV0b3ZhY3V1bV9uYXB0aW1lwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCA2MMKgwqDCoMKgwqDCoMKgwqAgfCBzCj4gYXV0b3Zh Y3V1bV92YWN1dW1fY29zdF9kZWxhecKgwqDCoMKgwqDCoMKgwqDCoCB8IDLCoMKgwqDCoMKgwqDC oMKgwqAgfCBtcwo+IGF1dG92YWN1dW1fdmFjdXVtX2Nvc3RfbGltaXTCoMKgwqDCoMKgwqDCoMKg wqAgfCAtMcKgwqDCoMKgwqDCoMKgwqAgfAo+IGF1dG92YWN1dW1fdmFjdXVtX2luc2VydF9zY2Fs ZV9mYWN0b3IgfCAwwqDCoMKgwqDCoMKgwqDCoMKgIHwKPiBhdXRvdmFjdXVtX3ZhY3V1bV9pbnNl cnRfdGhyZXNob2xkwqDCoMKgIHwgNTAwMMKgwqDCoMKgwqDCoCB8Cj4gYXV0b3ZhY3V1bV92YWN1 dW1fc2NhbGVfZmFjdG9ywqDCoMKgwqDCoMKgwqAgfCAwwqDCoMKgwqDCoMKgwqDCoMKgIHwKPiBh dXRvdmFjdXVtX3ZhY3V1bV90aHJlc2hvbGTCoMKgwqDCoMKgwqDCoMKgwqDCoCB8IDUwMDDCoMKg wqDCoMKgwqAgfAo+IGF1dG92YWN1dW1fd29ya19tZW3CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqAgfCAtMcKgwqDCoMKgwqDCoMKgwqAgfCBrQgo+IGxvZ19hdXRvdmFjdXVtX21p bl9kdXJhdGlvbsKgwqDCoMKgwqDCoMKgwqDCoMKgIHwgMMKgwqDCoMKgwqDCoMKgwqDCoCB8IG1z Cj4gKDE1IHJvd3MpCgpUaGVyZSBpcyBubyBuZWVkIHRvIGtlZXAgImFnZShkYXRmcm96ZW54aWQp IiBsb3csIGJ1dCBpZiB5b3Ugd2FudCB0byBkbyB0aGF0LCB0aGUgY29ycmVjdCB3YXkKaXMgdG8g cmVkdWNlICJhdXRvdmFjdXVtX211bHRpeGFjdF9mcmVlemVfbWF4X2FnZSIuCgpZb3VyIHNldHRp bmdzIGFyZSBwcmV0dHkgY3JhenkuICBZb3Ugd29uJ3Qgc3VjY2VlZCBpbiBhbnl0aGluZyBidXQg aGF2aW5nIGF1dG92YWN1dW0gcnVuCmFsbCB0aGUgdGltZS4gIFlvdSBzaG91bGQgcmVzZXQgdGhl IHRocmVzaG9sZHMgYW5kIHNjYWxlX2ZhY3RvcnMgdG8gdGhlIGRlZmF1bHQgdmFsdWVzLgoKVG8g bWFrZSBhdXRvdmFjdXVtIG1vcmUgYWdncmVzc2l2ZSAoaWYgdGhhdCBpcyBpbmRlZWQgbmVjZXNz YXJ5KSwgcmVkdWNlCiJhdXRvdmFjdXVtX3ZhY3V1bV9jb3N0X2RlbGF5Ii4gIEkgd291bGRuJ3Qg ZG8gdGhhdCBnbG9iYWxseSwgYnV0IG9ubHkgb24gdGhlIHRhYmxlcyB0aGF0CnJlY2VpdmUgbG90 cyBvZiB1cGRhdGVzIGFuZCBkZWxldGVzLgoKWW91cnMsCkxhdXJlbnogQWxiZQo=