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 1tKdxJ-009vWG-J2 for pgsql-performance@arkaria.postgresql.org; Mon, 09 Dec 2024 13:37:45 +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 1tKdxH-008kI6-3G for pgsql-performance@arkaria.postgresql.org; Mon, 09 Dec 2024 13:37:44 +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 1tKdxG-008kHY-Hp for pgsql-performance@lists.postgresql.org; Mon, 09 Dec 2024 13:37:43 +0000 Received: from mail-vi1eur05on20706.outbound.protection.outlook.com ([2a01:111:f403:2613::706] helo=EUR05-VI1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKdxD-001uHt-Fa for pgsql-performance@lists.postgresql.org; Mon, 09 Dec 2024 13:37:42 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=CqvkxFNEjq+RLYeTpkg6WzjWE6U+bC+NUNG7vumRLJMD1qB3uXhkHgE+Nq/2mYU1NcLS+4flHUD/CyiOwcxIhlNtndO9lOZ6II++5ppxsuANa3t2MHLkgOztD117HEX00JPebZv8xxUYA8QL2hxDViSXMUAe+eUmbyDLjeAoruy77IXWX6Exe1iWonMmqe49DvajukjTTwhJfUlr7InTtS+4q0ev8j9l3QNG/F9czC7P24glbMfnvsUBZPrA29m98oLkrth6/9WJjxfHAkFupupzr8+zM5K6YaeRVX8IFss2KZ2kh0lSBYWFHY1xhaIkTCjF6Gwp6DHmAAhS8/+8Ug== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=LYW+kXqLU9y+JLKmVysBETaWIeaoRpvw4O+mxvst2wU=; b=yFVvGBfYIRbC0BFkQh88YjtEQvUFEJPEDeXoXopJeY/VhBJDTxMa8v3Ni1uIMJqc2F9BiuikRb3BAma6825DP4QB0FwiB1M5OK7jT3MLDbssPhjg88sMDnn7FSZfxM3WsatmhjBf8x6J2Cjoae2V6xjz/97/YNsrQAu4ZBXSEf182xjnVJr+BEHuPz75/4RJ0d/q6BpM6JovAbwA7pdaYCFkVVGkExLldwgV+iY3Y3iwPCVQ7eArkfWutXCo0O9tZFdWj3WN59mAdBpc5bm0Ux95p2Z10+W6ZzeI2Z34i70nai0rSaIJn9n3J9mmYDnxKhxjvCV/KBjyC5oiH/j2dA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=nibio.no; dmarc=pass action=none header.from=nibio.no; dkim=pass header.d=nibio.no; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nibio.onmicrosoft.com; s=selector2-nibio-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=LYW+kXqLU9y+JLKmVysBETaWIeaoRpvw4O+mxvst2wU=; b=VisLa5Yxx/OtOLFrGBlR7K1DE3HYTxxNEVHCVttsXahnUVX6VNmlN+ZLHjQHF72FP3XEcmfFAuXEU2e38vpjGUM9NH+UEKFX7wskZJV4LJwq6LGp2W9SrJPI5Cs0hqhcjslElbFH3ULb83zNJHRWLgzm/lvmXZeijNDaKwQ/jmI= Received: from AM7P189MB1028.EURP189.PROD.OUTLOOK.COM (2603:10a6:20b:174::18) by AS8P189MB2417.EURP189.PROD.OUTLOOK.COM (2603:10a6:20b:57d::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8230.17; Mon, 9 Dec 2024 13:37:33 +0000 Received: from AM7P189MB1028.EURP189.PROD.OUTLOOK.COM ([fe80::7021:938f:7ff2:6406]) by AM7P189MB1028.EURP189.PROD.OUTLOOK.COM ([fe80::7021:938f:7ff2:6406%6]) with mapi id 15.20.8230.016; Mon, 9 Dec 2024 13:37:33 +0000 From: Lars Aksel Opsahl To: "MichaelDBA@sqlexec.com" CC: "pgsql-performance@lists.postgresql.org" Subject: Re: PostgreSQL and a Catch-22 Issue related to dead rows Thread-Topic: PostgreSQL and a Catch-22 Issue related to dead rows Thread-Index: AQHbSiR8fAE8+rgvhkWYwOHzJhBte7Ld5UAAgAACDxw= Date: Mon, 9 Dec 2024 13:37:33 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=nibio.no; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AM7P189MB1028:EE_|AS8P189MB2417:EE_ x-ms-office365-filtering-correlation-id: 95abbe6a-b674-408f-1b9b-08dd1856a2e5 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|41320700013|8096899003|7053199007|38070700018; x-microsoft-antispam-message-info: =?iso-8859-1?Q?I/j0N86DmCrUEwLZ8mF1fPEqrHyk5TvAVyNab6/osp0Ng6Apes2eEXNZqn?= =?iso-8859-1?Q?hxWSlDhJKgmfJYpY59l6gTcLKnwHcat6XpJx9MmTb9A0UrhtqVuXvx2X1A?= =?iso-8859-1?Q?QwMSXG+jXK8r6i6SPiqUaxS0TbrJlTv1y63AqrtKfMav5oiOXJTYo2s1SE?= =?iso-8859-1?Q?oaboEuPHjlaAhSkL3iqV98PkyjdRkxEiJbevwTE0nBK4b2vNbrOCUmsjzc?= =?iso-8859-1?Q?LlOD9t0H8YkT6+K5+IFyG3linvMjB1xWoYJDmgd5PT9T4pu1bq5z6yjQ/B?= =?iso-8859-1?Q?BT9lLEBWkuPSKIZQfs9wlSZyWVYG5cY21+SLVDc3ibR3ry585PhdgSe4Lh?= =?iso-8859-1?Q?C1aM2c1tn4O9t0DRbGHnoSwiXPPQGRZQNCpW3oTdy0l1E5nKwxzm2PgFzb?= =?iso-8859-1?Q?mQY9EArSTPNA4GEUUkV8yOeKmba5zgFXNGvnG+P87GNMVasaCpXEjN7g7r?= =?iso-8859-1?Q?NIOb5rtGtrTt0nXqfSJiQ2i/kqNTWF8ZuG4IMgGj1ndwdlCkvlhPRKKT/G?= =?iso-8859-1?Q?qZ1zlP+apOUNqNgStw+WgyWnGRS9vGauKYh+47cQsEQrMun6hckvEquZb1?= =?iso-8859-1?Q?vEz/+yzNydGJ7lQViBhYU9vbVOUkWZhMyUPsWd9+TOO5LvmkAJUEx/X9NI?= =?iso-8859-1?Q?QciixcUcVJdHfTfESNT4DCEaeEBKzDMkq/XIq9KEHPLgod3WqofQDMixbc?= =?iso-8859-1?Q?nepa1D3JOXwQqfzDgDlz1rtQuPeIhfAA2nrewKeWmshm4Chbrhzv5N5kRj?= =?iso-8859-1?Q?F4mO9rDDbynbdRspPWCURJt2rWb3vSTK8ZgP32Wrzidys7crle/QR9fxX5?= =?iso-8859-1?Q?V6K63gRyhjkXx5bN5yTbrpb8ExUveFpzM1zpOWdZu91x3VImsk0SgGuccb?= =?iso-8859-1?Q?lnGMFbaSEvjMeZAdTgPFCajsFHW4W3LdvQL0OKcusM3kAdX+HXLqK0rY2D?= =?iso-8859-1?Q?DIQlSccgm+ll8Dvt7mbm3rdpN4bqWOb9ROF7qE2wJ2l1/Yayo2MPWeJDaq?= =?iso-8859-1?Q?VyC8viaz1eaDmAkLxGWpFIznzmoBjEfhdpEzHMhHUV4L+ONbQoChwSaRPc?= =?iso-8859-1?Q?Lkkk+C24h+6Y724V/6K6VE+TfSf7zRv5TkcUW7E0wkXUuCPivVekm4rerO?= =?iso-8859-1?Q?nA92K6hfQHkejPFq3vCqIfFNFWS9gFS7h4Z672yrfbuqcuHdXTVOR7rRCE?= =?iso-8859-1?Q?m0M0JL0RhdEv5r6P9A6uiCloz8Y8uE//pqDuOHs9W/nXUQDxMPB6bqCS2H?= =?iso-8859-1?Q?rkuYJUPzVFvPWvui/kPXFnj01ixEfmwxyUFS4cm4iOYmzxkpmDMqgLMhIm?= =?iso-8859-1?Q?aknR+Q/vJNBIXw9aK16BZYb6QVlFwYMwBPFrCVLMj++YGx25rOhDuosTcS?= =?iso-8859-1?Q?BNTw6eAYTl5UB4Q3I2/OoZ7d3AJzlUVTa4l+DGTB+CMdPjX8TMap4u+UO6?= =?iso-8859-1?Q?ilPYEBvGKLjBDmnErY+Xmm78MeKAopyoG1Gmrg=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM7P189MB1028.EURP189.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(41320700013)(8096899003)(7053199007)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?gMEm0OnLHB9tfjzZo7i96qVggPIc9rg6zVBLRokJvWMlkcVykhFS6rc3Hr?= =?iso-8859-1?Q?Jr8cuy0AAmoTx9LDHv7GsdudgwybAfYo+qHx8sJeYAoto9t4ZGoMCR5RJo?= =?iso-8859-1?Q?84146Qsp+ojwjG9j0Dk9UuvdXBv1Pe1tBtmW6+7RjrBKwN4Vb7jNCFFL83?= =?iso-8859-1?Q?psHZQTLQnzuvi+g8aVmLFDZWfs4r8s6tXzdJBxJcI4uSgGGet+4cnpGkVx?= =?iso-8859-1?Q?LWCi0ZiTAR77kRNhhhfLD3H36apxu+teQPj+VCCHm/94SZ6VwAFwtaCw/C?= =?iso-8859-1?Q?CRxiGREvBKu/2svsWmbmfhZndc+YDv+KjtRl7uph6Vimf+vS20IGVxuQFu?= =?iso-8859-1?Q?aKF2EdyUlQaycNIizarX4HeiIXeiv1W7bB9fpC6UsB4/RoWlQwH02PNyZp?= =?iso-8859-1?Q?4DkWxa8Jq5GrxCL8byHuzjRQk+wtxJZT5HlFIeFKYQsoxkTGtXsOrsD7gZ?= =?iso-8859-1?Q?lkM0n/5Z5AWqssdHATQrQUkUsT943/eppD5qy75f59miLkfukqM3tIsszG?= =?iso-8859-1?Q?vwjBwrEbGOH5h0IEfwEz/ip0PoaLn0yOZTQBirNGd+2WpQ/F8SRquiLfyr?= =?iso-8859-1?Q?sBRBeuPTSlVS+LJlapj8JmEqGt3ooNBAxW/SvvufVedu9aptSjh8LjT7Ih?= =?iso-8859-1?Q?aouqPQ/69DtN2f7eSwV/SmYiv0jaifjn8utbF5mPtCJUj8z72vZPmAGe1U?= =?iso-8859-1?Q?7YiDm6NnZiPvpwwQpZUX3ycWlj4cL/GvCGufIX1UrnzV0+WSSCg9+qLvSU?= =?iso-8859-1?Q?IBnzHCLUWpWLkLXZfzTzapiGUtzXUnD+L4t4RTt99V5BNJGlcFp2BRxt/b?= =?iso-8859-1?Q?jxxJ4e3WbjT1Mz7sCNMFt4RqSEnna/YZhz9/816/XFiFTVG2u0A63Cy8mq?= =?iso-8859-1?Q?JMrBB/44Q/qsFH78kkbIq2FkKjHLEM9FwiKWLUm+yNOTWSGBThAayAzZJL?= =?iso-8859-1?Q?HtX+OzIUanZ7n7RWLZDeLr2uVhqvQQuonjED23yO7DG58TwsBdKIvu2Smk?= =?iso-8859-1?Q?8aoSzKHkum6Nvz0e+s6YRVVRTdqGg1izSUZLl9BHeF0DyGP71PBd5Q8cvN?= =?iso-8859-1?Q?iBugBA/1Z2oODYzsAG6S9Y6c9UF0E3rYze2B55TA1QcDlzubZmjnRlgQM0?= =?iso-8859-1?Q?+G4ydITPEsUVvScL8TgEgyW5MClMs40W1v5oSEDH843EScM8UDgD8piJJp?= =?iso-8859-1?Q?WzSoB0crBU+WS92AD10OO1/ZZQXZpBElTfP9YrDo0vJqnafOjQMZJb6hRj?= =?iso-8859-1?Q?2bOLUPt6+5uIOX3JBAC7TmTUxQaQ2t1UO5bINCn8LyDIelt5hA3qvPYSKR?= =?iso-8859-1?Q?KOMAcfN1ujwZa58iIaBOXcM6z5ZVyrHhIcAEECg8dppZZBwzp2iNnL1Zvh?= =?iso-8859-1?Q?ko6bfkCz5wST9MEOv2ozcmJ8kLiDxGKdhQ+bbGn1xmtz2GG6Zyr29tcfXM?= =?iso-8859-1?Q?kPvk4WnKj6AH8Nms8qvozK2kQ+/bmMB2P/4E2wpzzdckTc0U/kKvCsMmv5?= =?iso-8859-1?Q?Y/iXgmrQeau5139EmwRcrXZlKRPhXwyhgqGOPAHqqsrvP7oeMkraEN1VDv?= =?iso-8859-1?Q?iqqwbUtqUBcsEH9rUlmfCa0iOCkRHqLP9Q7Dos6z2MgYXs0lqdncsFiUnm?= =?iso-8859-1?Q?YVQincTyCkcfQ=3D?= Content-Type: multipart/alternative; boundary="_000_AM7P189MB1028BA1F3FFE08B1517F85CD9D3C2AM7P189MB1028EURP_" MIME-Version: 1.0 X-OriginatorOrg: Nibio.no X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM7P189MB1028.EURP189.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 95abbe6a-b674-408f-1b9b-08dd1856a2e5 X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Dec 2024 13:37:33.5466 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6df9a8ea-1ed0-462c-85a8-831200d5f7c5 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: dlIrb7OW2FF3/xbKvUF3FFs/F18MRjvVvjsStqlgUYG6I+9TzGUp0AqKZZaKxJRppIXm5uwlVLrLJ5/4bawepw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS8P189MB2417 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AM7P189MB1028BA1F3FFE08B1517F85CD9D3C2AM7P189MB1028EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ From: MichaelDBA@sqlexec.com Sent: Monday, December 9, 2024 2:18 PM To: Lars Aksel Opsahl Cc: pgsql-performance@lists.postgresql.org Subject: Re: PostgreSQL and a Catch-22 Issue related to dead rows You could always turn off vacuuming at the table level and then resume late= r Sent from my iPhone Hi I am running without auto vacuuming for those tables already.