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 1qnkjU-00BrVT-Fi for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Oct 2023 19:07:00 +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 1qnkjR-0088Ox-HC for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Oct 2023 19:06:57 +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 1qnj9v-007cEb-OE for pgsql-bugs@lists.postgresql.org; Tue, 03 Oct 2023 17:26:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnj9q-0080yQ-Bj for pgsql-bugs@lists.postgresql.org; Tue, 03 Oct 2023 17:26:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=e6PHyWSd23o48zEJbtY/TibjNP8Op5vleBmhdrKnPHk=; b=JLRWG66CZqzoBMBjXRwFZVZ5e7 e5oE9HT/NpkNSNZbtYeMtUFpAQJYThrX+GRuKFb7Jt1lHuLVXxeL+1NpZBvPwEgIBcoxogAUB3/6C XxFj4mDfzdIPluR56omiAiDF8gKxrwu2J7ngL5wc3DoIhzS/cLGSL2zDZlMrie0JSD3B9AHEonBAL cWEeGVQLVYFc3vVNAb6nUK2UgwiEIFWXtgfR+P7dQvqIvxP4Z4gaLXVi07FE8wOzkTxqL6GMXHu0J bgaLV2WTyWzsoN8jPvnMfgaRrUeEXf06bEy2Js1imr/HRM5/TqANNse4obCMr2W621ak1Luee6C7P ABZmXVGw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qnj9p-0006x4-Qz for pgsql-bugs@lists.postgresql.org; Tue, 03 Oct 2023 17:26:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnj9m-0094uI-LA for pgsql-bugs@lists.postgresql.org; Tue, 03 Oct 2023 17:26:02 +0000 Content-Type: multipart/mixed; boundary="===============4823371037525375847==" MIME-Version: 1.0 Subject: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rootcause000@gmail.com Reply-To: rootcause000@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 03 Oct 2023 17:25:17 +0000 Message-ID: <18146-04e908c662113ad5@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4823371037525375847== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE0NgpMb2dnZWQgYnk6ICAgICAgICAgIFJvb3QgQ2F1c2UKRW1haWwg YWRkcmVzczogICAgICByb290Y2F1c2UwMDBAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog VW5zdXBwb3J0ZWQvVW5rbm93bgpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MKRGVzY3JpcHRp b246ICAgICAgICAKClZlcnNpb246IFBvc3RncmVTUUwgMTAuMjEsIGNvbXBpbGVkIGJ5IFZpc3Vh bCBDKysgYnVpbGQgMTgwMCwgNjQtYml0DQoNClBsYXRmb3JtOiBXaW5kb3dzDQoNCkluIG91ciBh cHBsaWNhdGlvbiBjb2RlLCB3ZSd2ZSBpbXBsZW1lbnRlZCBsb2dpYyB0byBjbGVhbiB1cCBlbnRy aWVzIGluCnNldmVyYWwgUG9zdGdyZVNRTCB0YWJsZXMgdXNpbmcgYSBsb29wLiBBbHRob3VnaCBz b21lIG9mIHRoZXNlIHRhYmxlcyBoYXZlCmZvcmVpZ24ga2V5IHJlZmVyZW5jZXMsIHdlJ3ZlIGlu Y2x1ZGVkIHRoZW0gdG8gZW5zdXJlIGEgdGhvcm91Z2ggZGVsZXRpb24KcHJvY2Vzcy4gSGVyZSdz IGEgc2ltcGxpZmllZCBjb2RlIHNuaXBwZXQ6DQoNClN0cmluZyB0YWJsZXNbXSA9IHsiVGFibGVB IiwgIlRhYmxlQiIsICJUYWJsZUMiLCAiVGFibGVEIiwgIlRhYmxlRSIsCiJUYWJsZUYiLCAiVGFi bGVHIiwgIlRhYmxlSCJ9Ow0KDQpmb3IgKFN0cmluZyB0YWJsZU5hbWUgOiB0YWJsZXMpIHsNCiAg ICB0cnkgew0KICAgICAgICBzdG10ID0gY29ubi5wcmVwYXJlU3RhdGVtZW50KCJERUxFVEUgRlJP TSAiICsgdGFibGVOYW1lKTsNCiAgICAgICAgc3RtdC5leGVjdXRlKCk7DQogICAgfSBjYXRjaCAo RXhjZXB0aW9uIGV4KSB7DQogICAgICAgIC8vIExvZyB0aGUgZXhjZXB0aW9uDQogICAgfQ0KfQ0K Tm90YWJseSwgaXQgbGVhdmVzIGVudHJpZXMgaW4gZGlmZmVyZW50IHRhYmxlcyBlYWNoIHRpbWUs IGFuZCB3ZSd2ZSBmb3VuZAphdXRvLXZhY3V1bSBmYWlsdXJlIHRyYWNlcyBpbiB0aGUgcGdfbG9n IGZvciB0aGVzZSB0YWJsZXMgYXQgdGhlIHNhbWUgdGltZS4KSGVyZSdzIGFuIGV4YW1wbGUgb2Yg dGhlIGVycm9yIG1lc3NhZ2VzIGZyb20gcGdfbG9nOg0KDQoyMDIzLTA5LTI4IDEyOjAzOjM1Ljk1 NSBJU1QsLCwxMTU5MiwsNjUxNTFlMmQuMmQ0OCwxLCwyMDIzLTA5LTI4IDEyOjAzOjE3CklTVCw2 LzE5LDEyMjc4NjI2MixFUlJPUiw0MjUwMSwiY291bGQgbm90IHRydW5jYXRlIGZpbGUKIiJiYXNl LzE2NTA5LzY5MzUwMjYiIiB0byAwIGJsb2NrczogUGVybWlzc2lvbiBkZW5pZWQiLCwsLCwiYXV0 b21hdGljIHZhY3V1bQpvZiB0YWJsZSAiIkRCLnB1YmxpYy5UYWJsZUIiIiIsLCwsIiIgMjAyMy0w OS0yOCAxMjowMzozNy4yMDUKSVNULCwsMTE1OTIsLDY1MTUxZTJkLjJkNDgsMiwsMjAyMy0wOS0y OCAxMjowMzoxNwpJU1QsNi80NSwxMjI3ODYzMjYsRVJST1IsNDI1MDEsImNvdWxkIG5vdCB0cnVu Y2F0ZSBmaWxlCiIiYmFzZS8xNjUwOS82OTM1NDQzIiIgdG8gMCBibG9ja3M6IFBlcm1pc3Npb24g ZGVuaWVkIiwsLCwsImF1dG9tYXRpYyB2YWN1dW0Kb2YgdGFibGUgIiJEQi5wdWJsaWMuVGFibGVC IiIiLCwsLCIiDQoNCldlJ3ZlIGFscmVhZHkgYXR0ZW1wdGVkIHRvIGV4Y2x1ZGUgdGhlIGVudGly ZSBwZyBmb2xkZXIgZnJvbSBhbnRpdmlydXMKc2NhbnMsIGJ1dCB0aGUgcHJvYmxlbSBwZXJzaXN0 cy4gQW55IGluc2lnaHRzIG9yIHNvbHV0aW9ucyB0byB0aGlzIGlzc3VlCndvdWxkIGJlIGdyZWF0 bHkgYXBwcmVjaWF0ZWQuIFRoYW5rIHlvdSEKCg== --===============4823371037525375847==--