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 1qtWW7-00Chg0-AE for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 17:09:03 +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 1qtWW4-004bwj-S7 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 17:09:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtWW3-004bvu-WC for pgsql-admin@lists.postgresql.org; Thu, 19 Oct 2023 17:09:01 +0000 Received: from mail-dm3gcc02on2134.outbound.protection.outlook.com ([40.107.91.134] helo=GCC02-DM3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtWVz-001ZxC-Qj for pgsql-admin@postgresql.org; Thu, 19 Oct 2023 17:08:59 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=EhrSRpF/lrpzg6M3XnZ+G7ZZ4dD4Vhy/Pnxnk13ewRUng4BYaBb4u8IuNaV6ENcBSv/Dyf6eBVpLwUJTvxwH6uf1cTCKT1qELKjzEiMVNCveOj7goGigBP9fKahMMl9NwQ1qUS40nHWQOf01Tl7WZtm1yzSNhBZ5nOFOOT+7kyuMZmRwzwoelcE4l6xCsM8ANcMb3sIy4HaOuvnN1Kk7KmSQ/UXDn/2HdehP/72FolkR0AI08aP3rqkTyW0X1aWayKzU7JVYkXRKQhsWW8BtI3/UFYnNtAKtGDFw9oL8Bq9E1JxKtTshaJVAPfazHQRXt2E/EYKPWFzYCdOmK1WUsQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=boYfvZ8Jl7e9YvofljtYIDG1y353OoLie8ddWgo4ST0=; b=nvRl0ID50+v44L+dY89+tSIgGWuI13j5BA8RIZvktqqbtl8mi9r4Tqwl86RouYIC1hAsdg4B5skfkS8bXQtlR3CWOkODA7ELVYBXQ03SN+K5R+z3qemaGZRbPdGp1tqwZbxhXf2DgKHRfi8sCm/lOJrSy2m1zHph7cRAYCvRwKCPda77F3sAq9UJONkUhx0ny+uEJvHYVoH5Ese6NX46uzxiXmsWZBf9FI2DR0mfZQRqA50dyyTR9hV0S5iqhVs0op3nkPIZ94iNMbBwSeYPV4rZeERu5hiYNanyoEEPFwPmWre3X0H287y39QhdQwa/qQdiahaOMqjrApMFiJmkWA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fnal.gov; dmarc=pass action=none header.from=fnal.gov; dkim=pass header.d=fnal.gov; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fnal.gov; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=boYfvZ8Jl7e9YvofljtYIDG1y353OoLie8ddWgo4ST0=; b=j+08o1BpYQ+Q10mLzdvTqXIdzKmiW35lGHMghEpyRKhnkaL7KX7fZXJXoyb6HNBZynuwRmCdaY9ibAaE29nN2JcB7NIwk0Va+C/BtgQWc7rHjm07LKGJwYELTtqWPNP7Cc+pqF+y1eq3Ir1FRI04LclFeNdJvIBHEO8Go6kILaO0LdhxdP773qMg1DVZ4gRkBqGoqDCgkOzMqJ3Rz6lz3hba7Svr6iT1HS/ftafhTDG12m/h1ezyBO5tcbQEWKpDjC5iczWjuIsay5XAjOtiz8w8ZcOwe/PHek8oW7t3aNWY45Qu7kmXvy1As9SfaPqwEujtN3ZoZVvUaJjjCr5cOg== Received: from DM8PR09MB6677.namprd09.prod.outlook.com (2603:10b6:5:2ee::12) by DM8PR09MB6374.namprd09.prod.outlook.com (2603:10b6:5:2e4::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6886.35; Thu, 19 Oct 2023 17:08:52 +0000 Received: from DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::c68c:f3f6:717e:1eda]) by DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::c68c:f3f6:717e:1eda%3]) with mapi id 15.20.6863.043; Thu, 19 Oct 2023 17:08:52 +0000 From: Murthy Nunna To: "depesz@depesz.com" CC: "pgsql-admin@postgresql.org" Subject: RE: Vacuumdb on a table Thread-Topic: Vacuumdb on a table Thread-Index: AdoB/PzeqJ4SW6LsTCeOSNQJAkSFnwAaRdaAABHG3TA= Date: Thu, 19 Oct 2023 17:08:52 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fnal.gov; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM8PR09MB6677:EE_|DM8PR09MB6374:EE_ x-ms-office365-filtering-correlation-id: 78e717ea-3e3a-4cb4-bf62-08dbd0c611da x-fermilab-sender-location: inside x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: SDJd/AbZHqD9zMyeBDXNHCs/B5qNeLp8AZ8SZoSYwNCnkaBq4BcgzfxCrTqLOkHBAvLXBNFyp2TiU+/m1kx4/XFFNNA9oebxprx9KDH4Xcdb9QZS4+S/3r0rFczBjwHzq6kByYPDL6RsByGWpHNbNh9X5ik1Zq6m3qbN0Od4+fZNBzba+Y/ESblc7ngqXw+jVJRxPeix6oyat4p/83M7o3QD5H+USRMMGujuB9A/xvSuWQSDMCYjo8fQRmfZle/iNLSJg69PPviXwiHD0Gan6UNJOsutZchSdsXScfESu0CL3hpxliXwUB+VDnEze2L8X2PXnTPHB3+X1nUWHGkAheFhAJGar+sK1MsZV03KAR4lDDAZMywnMSpXv9u/HpnmRgI+MxVJ/Qag0XM97l8ryFmpQG2Q9EIDKGG/+IZDaf9Wn76FdIRmX4Tu/CUv8RZIjRDm6cEj9fjlS1F/lEP+gERKC55PN7LpHzIVulB5qa0cyRJPfko9aucjxFQTLW4ATBd1vLWvJRVdwauZYSJ8+DiCN7RX68iyfajXdhxyQGKy8fmhgiB7+oFPuK8UXItmgx+utVOEfy4CBlSE4x4hvX8MI4PS+ifubWyRNtQyZfs9cmDC8wDpGMsdovpSlM39 x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DM8PR09MB6677.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366004)(230922051799003)(451199024)(186009)(1800799009)(38070700009)(55016003)(508600001)(66476007)(76116006)(66946007)(66446008)(6916009)(66556008)(64756008)(71200400001)(86362001)(82960400001)(3480700007)(6506007)(83380400001)(38100700002)(4326008)(26005)(53546011)(7696005)(33656002)(122000001)(9686003)(5660300002)(52536014)(2906002)(8676002)(8936002);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?ME9VdGFOZkprUkZMYVplVjl3YkkwODdYREVSRUFsb0FBRkhvWkwyK0pIT2p6?= =?utf-8?B?RzJlWjhPYkRlQkszV1hIdGMvYlI0YlZ1ajFPc0lTN1IxWHJOSkNXREptcHpy?= =?utf-8?B?dS8yR3ZZYzgyUDJGdTdmTTFoa05CRTJQLzRaMGVDWEpFRENZYmFuY0t5bmp6?= =?utf-8?B?ak9FbWthdG5aQlpRS05YNk5tZmNYQWFjL1BvREJaL2Y2NGhXa0lqRmxCMUht?= =?utf-8?B?bFppanNlL292b1JyeFd1MnVSRVAwWnQ2SGJCaW9FRUs1cFVNRVRMYVU5bGhP?= =?utf-8?B?dndEcDNLb0hOd0M2MVZCMzdyU3FGSEE0dHNEZnU2SUFVRVcyUW12Ky9MMW1t?= =?utf-8?B?anNoSWE4RmlvZGV1NHI5cTJzb05KNDFKZEQvdzNNL1IyTWlIMkk2Tk05YlA1?= =?utf-8?B?NkZTTmVZTEJXdEVMS05oRlBaSHcwMFYxYUtyOXdjQjlDK0dyQ0pUYU5ra0lm?= =?utf-8?B?S3hQRVVKUng3YTY3L004QTZqRVhyM3RnSGxlYnVhMUtHVW9wNWZlOXRLTzky?= =?utf-8?B?TkwxV2VIYzVKUUtlb24wcXlCeUovRHQ1Tmc4MTY3WElia1hlcE9PV01KUlBW?= =?utf-8?B?MFY3RVU3NEc0QWZKK3FjMDZUZGlyVlpkdm1KMkhzYVdQT0wzRENYakZXYzVI?= =?utf-8?B?K3Q4VUd6Zmo0R212NmdncXdhQUdING1zclplT2J3QVNKSG1adlZwQ2V0TGQ1?= =?utf-8?B?MXdmaDhLdU5NUDVzZmVSZDVsWHVFSGRzam5talRUaG53NDRQaFRJTlFRUDBO?= =?utf-8?B?eHlCbmp6aW9VS2d2am4yNGJCbEpBVHRTeGNYUWhxU1lqbU5nUWJONS9CMzRq?= =?utf-8?B?dm5YS3VhU0hiNDY2eTQ3Y1VsMnRSR1ZTK2FjOEMwMi9EOGVYRnhLMmcwN0dl?= =?utf-8?B?NGUvL2pJMzRwSG9ZNlhlaVlRei9iYmR4dXllZGFRUXROUzhoMGUzU2YxMng2?= =?utf-8?B?VVNsMGJhV3hyS04xTTI4ai9QQk40bFpFV0RyZVVLdnlOejljQkxjR1dXMUJW?= =?utf-8?B?eEZqc0tYZjF6dThrb3lPR3NyeGZGcjBwb0ZlY044V2hoV2NXc1M5TEF1V1or?= =?utf-8?B?RjlGeDlDL2ZKZGxyL1Q1OXJYZ3VmZngrMnEycDV1V2ZodC9OeGE0Rkpjbjkw?= =?utf-8?B?bThia0IyODg2MEg2Vjc2QW1aZTBTTStQS0Q2VzF2N3I0YUFSdDlrZU5JNVBU?= =?utf-8?B?bWZlQXdIakQ5Sks3MStKUmFiMTlXMG5GcTZBZjA3UVpoOUk1WStTOERRMkNT?= =?utf-8?B?R014T0Z1WnNBeml6L2tlWVlrNDNyc1grc28zcXhGOHFJaXFXL0RKL2ZYU2Zr?= =?utf-8?B?VmtHbE4zQ1dsd3lqbzUrNEdudmV0dFU2dmlxaVB4cGxGenMwWHBPVUovK2Jo?= =?utf-8?B?T2Q4elBPT0d0aXd5cE92dXRiU2xpbUw3ZTRpMW9sMmtMNVFYWWlJYWFNdnJr?= =?utf-8?B?UVZDV3p4Nmc4N2FxbTJUeDJSUFVRbEJBMXplNmhsSFF2cXNzbE1ncDhNSWNK?= =?utf-8?B?RFNhaWVWYVlUUjEyRjU3aHJBSHU1S2haUlZTMXQ1cXFSNThMNlVON1Z1UHBX?= =?utf-8?B?TDdQNnc0OWJ1ckh0SjYySVlEb2gxL1JkQTNBcWQyT3QyMk5xY3JVVUVVVUhN?= =?utf-8?B?ZlIzM2oyTmhobTNVYkZmY1JhRVAyTlhtUHlJQ1BsQWRDSlRTMVFqbUd0cHBW?= =?utf-8?B?bEc3eHQ3eTdsaUhDMGpsdCtCc3diT1hFeUs5NDlUdDFidzk5RXVEd2M5QXMv?= =?utf-8?B?aWM3TkxwVHYvS3RWNFJaQ1kyL3ZjR3ljWFRLQVJTekhsQWsxclZ5TDdTT0M0?= =?utf-8?B?a0tsbHRnVW80WDRWN1lJanpZaGNLMHNLNE9tWXRwR3hsOHpjSTRnUEwwc0JQ?= =?utf-8?B?MHhmZXlVZmplZ1VPRkV2YktZb3BQb21NQUFCVXJNbldMVTVIbVgvRG5ZZGZY?= =?utf-8?B?b3FYdEhxWi8yK3ptem5NSmtmd0xqUGM1RTZ3cHB1SEpNNmdLeDloUnRPUzZ0?= =?utf-8?B?NittNGFwakg1eEdaL0tyVFNHaGErMEJVazNaVjVSRVFSbllUOFBMSEt6VHBE?= =?utf-8?B?a2FMamV5MzdTbC91QlQ1YkVrZzY5NFZGb3AwNlc1OStoSmkzN2Q0USszUTg0?= =?utf-8?Q?VjIfo+Xode6x2w8g0Lkj55b8W?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: fnal.gov X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM8PR09MB6677.namprd09.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 78e717ea-3e3a-4cb4-bf62-08dbd0c611da X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Oct 2023 17:08:52.4190 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM8PR09MB6374 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmtzLg0KDQpJIHJldHJpZWQgd2l0aCAtRi4gVGhhdCBhY3R1YWxseSB3b3JrZWQgYW5kIGxv d2VyZWQgdGhlIHJlbGZyb3plbnhpZCBvZiB0aGUgdGFibGUuDQoNCjEpIEkgYW0gd29uZGVyaW5n IGlmIC1GIG9wdGlvbiBpbnRlcmZlcmVzIHdpdGggYXBwbGljYXRpb24gKHRhYmxlIGxvY2ssIHJv dyBsb2NrIGV0YykuDQoyKSBJdCBzYXlzICJhZ2dyZXNzaXZlbHkgdmFjdXVtaW5nICI8dGFibGU+ Ii4gRG8geW91IGFsd2F5cyBzZWUgdGhpcyB3aXRoIC1GIG9wdGlvbj8gSXMgaXQgaGFybWxlc3Mg aW4gdGVybXMgb2YgbG9ja2luZyBzZWxlY3QvaW5zZXJ0L3VwZGF0ZS9kZWxldGUgc3RhdGVtZW50 cyBmcm9tIGFwcGxpY2F0aW9uPw0KDQp2YWN1dW1kYiAtdiAtZCA8ZGF0YWJhc2U+IC10IDx0YWJs ZT4gLUYNCg0KdmFjdXVtZGI6IHZhY3V1bWluZyBkYXRhYmFzZSAiPGRhdGFiYXNlPiINCklORk86 ICBhZ2dyZXNzaXZlbHkgdmFjdXVtaW5nICI8dGFibGU+Ig0KSU5GTzogIGxhdW5jaGVkIDEgcGFy YWxsZWwgdmFjdXVtIHdvcmtlciBmb3IgaW5kZXggY2xlYW51cCAocGxhbm5lZDogMSkNCklORk86 ICB0YWJsZSAiPHRhYmxlPiI6IGZvdW5kIDAgcmVtb3ZhYmxlLCAxNzIyMTgzNTAgbm9ucmVtb3Zh YmxlIHJvdyB2ZXJzaW9ucyBpbiA2MzMyMTY2IG91dCBvZiA2MzMyMTY2IHBhZ2VzDQpERVRBSUw6 ICAwIGRlYWQgcm93IHZlcnNpb25zIGNhbm5vdCBiZSByZW1vdmVkIHlldCwgb2xkZXN0IHhtaW46 IDE0NjU2NDgyMTQNClNraXBwZWQgMCBwYWdlcyBkdWUgdG8gYnVmZmVyIHBpbnMsIDAgZnJvemVu IHBhZ2VzLg0KQ1BVOiB1c2VyOiAxMzQuMTUgcywgc3lzdGVtOiAxOTkuODggcywgZWxhcHNlZDog MTg1Ni42NyBzLg0KSU5GTzogIGFnZ3Jlc3NpdmVseSB2YWN1dW1pbmcgInBnX3RvYXN0LnBnX3Rv YXN0Xzx0b2FzdHJlZj4iDQpJTkZPOiAgdGFibGUgInBnX3RvYXN0Xzx0b2FzdHJlZj4iOiBmb3Vu ZCAwIHJlbW92YWJsZSwgMCBub25yZW1vdmFibGUgcm93IHZlcnNpb25zIGluIDAgb3V0IG9mIDAg cGFnZXMNCkRFVEFJTDogIDAgZGVhZCByb3cgdmVyc2lvbnMgY2Fubm90IGJlIHJlbW92ZWQgeWV0 LCBvbGRlc3QgeG1pbjogMTQ2NTY5MzMyNA0KU2tpcHBlZCAwIHBhZ2VzIGR1ZSB0byBidWZmZXIg cGlucywgMCBmcm96ZW4gcGFnZXMuDQpDUFU6IHVzZXI6IDAuMDAgcywgc3lzdGVtOiAwLjAwIHMs IGVsYXBzZWQ6IDAuMDAgcy4NCg0KVGhhbmtzLg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0t LQ0KRnJvbTogZGVwZXN6QGRlcGVzei5jb20gPGRlcGVzekBkZXBlc3ouY29tPiANClNlbnQ6IFRo dXJzZGF5LCBPY3RvYmVyIDE5LCAyMDIzIDM6MjcgQU0NClRvOiBNdXJ0aHkgTnVubmEgPG1udW5u YUBmbmFsLmdvdj4NCkNjOiBwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6 IFZhY3V1bWRiIG9uIGEgdGFibGUNCg0KT24gV2VkLCBPY3QgMTgsIDIwMjMgYXQgMDg6MDU6NTNQ TSArMDAwMCwgTXVydGh5IE51bm5hIHdyb3RlOg0KPiBIaSwNCj4gDQo+IFRoZSBmaXJzdCB0YWJs ZSBpbiB0aGUgZm9sbG93aW5nIHF1ZXJ5IHJlc3VsdGVkIGluIGFnZShjLnJlbGZyb3plbnhpZCkg DQo+ID0gMTQ4Nzk1Mzk2LiBCdXQgd2hlbiBJIG1hbnVhbGx5IHJ1biB2YWN1dW1kYiBjb21tYW5k ICh2YWN1dW1kYiAtZCBkYjEgDQo+IC10IHRhYjEpIG9uIHRoYXQgdGFibGUgaXQgaXMgbm90IGxv d2VyaW5nIHRoZSByZWxmcm96ZW54aWQuIFRoZXJlIGlzIA0KPiBubyBpbmRpY2F0aW9uIGluIHRo ZSBwZ2xvZyB0aGF0IHZhY3V1bWRiIGZhaWxlZC4NCg0KUmV0cnkgd2l0aCB2YWN1dW1kYiAtRg0K DQpCZXN0IHJlZ2FyZHMsDQoNCmRlcGVzeg0KDQo=