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 1kGIVz-0003oE-Og for pgsql-bugs@arkaria.postgresql.org; Thu, 10 Sep 2020 09:05:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kGIVy-0001jA-MO for pgsql-bugs@arkaria.postgresql.org; Thu, 10 Sep 2020 09:05:10 +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 1kGIDb-0003Kl-Fl for pgsql-bugs@lists.postgresql.org; Thu, 10 Sep 2020 08:46:11 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kGIDV-0000tF-3q for pgsql-bugs@lists.postgresql.org; Thu, 10 Sep 2020 08:46:11 +0000 Content-Type: multipart/mixed; boundary="===============7698775546377051543==" MIME-Version: 1.0 Subject: BUG #16614: Stale temporary objects makes vacuum ineffective when 1 million transactions remain To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: gsaviane@gmail.com Reply-To: gsaviane@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 10 Sep 2020 08:45:19 +0000 Message-ID: <16614-23e5c4c4567d1576@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7698775546377051543== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYxNApMb2dnZWQgYnk6ICAgICAgICAgIEdpb3JnaW8gU2F2aWFuZQpF bWFpbCBhZGRyZXNzOiAgICAgIGdzYXZpYW5lQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDkuNS4yMwpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpX ZSBub3RpY2VkIHRoZSBzYW1lIGlzc3VlIGRlc2NyaWJlZCBiZWxvdyBvY2N1cnJpbmcgbXVsdGlw bGUgdGltZXMgaW4gc29tZQpvZiBvdXIgbWFueSBQb3N0Z3JlcyA5LjUgZGVwbG95bWVudHMuDQoN ClRoZSBhcHBsaWNhdGlvbiBtYWtlcyBleHRlbnNpdmUgdXNlIG9mIHRlbXBvcmFyeSB0YWJsZXMu IEFsdGhvdWdoIHRoZXJlIGFyZQpzY2hlZHVsZWQgYWN0aXZpdGllcyBmb3IgcmVndWxhcmx5IHZh Y3V1bWluZyB0aGUgZGF0YWJhc2UsIGFmdGVyIHNvbWUgbW9udGhzCm9mIHVwdGltZSB0aGUgZGF0 YWJhc2UgZ2V0cyBpbnRvIHRoZSAxIG1pbGxpb24gdHJhbnNhY3Rpb25zIGxpbWl0LiBFdmVuCnRo b3VnaCB3ZSBwZXJmb3JtIGEgbWFudWFsIG1haW50ZW5hbmNlIGJ5IHZhY3V1bWluZyBpbiBzaW5n bGUgdXNlciBtb2RlLCB0aGUKc2VydmVyIGtlZXBzIHJldHVybmluZyB0aGUgc2FtZSB3YXJuaW5n IGFuZCBoaW50Og0KDQpXQVJOSU5HOiAgZGF0YWJhc2UgIm15ZGIiIG11c3QgYmUgdmFjdXVtZWQg d2l0aGluIChYPDEwMDAwMDApIHRyYW5zYWN0aW9ucw0KSElOVDogIFRvIGF2b2lkIGEgZGF0YWJh c2Ugc2h1dGRvd24sIGV4ZWN1dGUgYSBkYXRhYmFzZS13aWRlIFZBQ1VVTSBpbgoibXlkYiIuDQoN CkFueSBmdXJ0aGVyIHZhY3V1bSBjb21tYW5kIGlzc3VlZCBjb21wbGV0ZXMgYnV0IHRoZSB3YXJu aW5nIGtlZXBzIHNob3dpbmcKdXAsIGFuZCB0aGUgcmVtYWluaW5nIHRyYW5zYWN0aW9ucyBhcmUg ZGVjcmVtZW50ZWQuDQoNCk9ubHkgYnkgcmVtb3ZpbmcgYWxsIHRoZSBzdGFsZSB0ZW1wb3Jhcnkg b2JqZWN0cyB3aXRoDQoNCiBETyAkJCANCiAgREVDTEFSRSByZWMgUkVDT1JEOyANCiAgQkVHSU4g Rk9SIHJlYyBJTiANCiAgICBTRUxFQ1QgJ0RST1Agc2NoZW1hICcgfHwgbnNwbmFtZSB8fCAnIENB U0NBREUnIEFTIHN0bXQgDQogICAgRlJPTSBwZ19jYXRhbG9nLnBnX25hbWVzcGFjZSANCiAgICBX SEVSRSBuc3BuYW1lIExJS0UgJ3BnX3RlbXAlJyBPUiBuc3BuYW1lIExJS0UgJ3BnX3RvYXN0X3Rl bXAlJyANCiAgICAgIExPT1AgDQogICAgICAgIEVYRUNVVEUgcmVjLnN0bXQ7IA0KICAgICAgRU5E IExPT1A7IA0KICBFTkQ7DQokJA0KDQpNYWtlcyB0aGUgdmFjdXVtIGNvbW1hbmQgY29tcGxldGUg d2l0aG91dCB3YXJuaW5ncy4NCg0KV2UgdGhpbmsgdGhhdCBzdGFsZSB0ZW1wb3Jhcnkgb2JqZWN0 cyBhcmUgc29tZWhvdyBibG9ja2luZyB0aGUgdmFjdXVtaW5nIG9mCnRoZSBkYXRhYmFzZS4KCg== --===============7698775546377051543==--