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 1jaKu9-0007F7-GQ for pgsql-bugs@arkaria.postgresql.org; Sun, 17 May 2020 15:08:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jaKu7-0000xa-97 for pgsql-bugs@arkaria.postgresql.org; Sun, 17 May 2020 15:08:39 +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 1jaKgy-0006wP-P1 for pgsql-bugs@lists.postgresql.org; Sun, 17 May 2020 14:55:04 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jaKgw-00077Y-LJ for pgsql-bugs@lists.postgresql.org; Sun, 17 May 2020 14:55:04 +0000 Content-Type: multipart/mixed; boundary="===============1632418204794812486==" MIME-Version: 1.0 Subject: BUG #16444: Vacuum writes the table twice To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kurt@roeckx.be Reply-To: kurt@roeckx.be, pgsql-bugs@lists.postgresql.org Date: Sun, 17 May 2020 14:54:12 +0000 Message-ID: <16444-4c2f66fed04080b8@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1632418204794812486== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ0NApMb2dnZWQgYnk6ICAgICAgICAgIEt1cnQgUm9lY2t4CkVtYWls IGFkZHJlc3M6ICAgICAga3VydEByb2Vja3guYmUKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi4zCk9w ZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJIGhhZCBhIGxh cmdlIHF1ZXJ5IGZhaWwsIHdoZXJlIG1vc3Qgb2YgdGhlIGRhdGEgd2Fzbid0IGNvbW1pdGVkLCBh bmQgYSB2ZXJ5CnNtYWxsIGFtb3VudCB3YXMuIFNvIEkgZGVjaWRlZCB0byBydW4gdmFjdXVtIG9u IHRoZSB0YWJsZS4gVGhlIHNpemUgb2YgdGhlCnRhYmxlIGlzOg0KICAgICAgICAgdGFibGVfbmFt ZSAgICAgICAgICB8IHRhYmxlX3NpemUgfCBpbmRleGVzX3NpemUgfCB0b3RhbF9zaXplDQotLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tDQogInB1YmxpYyIuImN0X2VudHJ5X2NoYWluIiAgIHwgMjcgR0IgICAgICB8IDM5 IEdCICAgICAgICB8IDY2IEdCDQoNClRoZSB0YWJsZSBsb29rcyBsaWtlOg0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLmN0X2VudHJ5X2NoYWluIg0KICAgICBD b2x1bW4gICAgIHwgIFR5cGUgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAgICAgICAgICAgICAg ICAgIERlZmF1bHQNCi0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0t LS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlkICAg ICAgICAgICAgIHwgYmlnaW50IHwgICAgICAgICAgIHwgbm90IG51bGwgfApuZXh0dmFsKCdjdF9l bnRyeV9jaGFpbl9pZF9zZXEnOjpyZWdjbGFzcykNCiBjdF9lbnRyeV9pZCAgICB8IGJpZ2ludCB8 ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBjZXJ0aWZpY2F0ZV9pZCB8IGJpZ2ludCB8ICAgICAg ICAgICB8IG5vdCBudWxsIHwNCkluZGV4ZXM6DQogICAgImN0X2VudHJ5X2NoYWluX3BrZXkiIFBS SU1BUlkgS0VZLCBidHJlZSAoaWQpDQogICAgImN0X2VudHJ5X2NoYWluX2N0X2VudHJ5X2lkX2Nl cnRpZmljYXRlX2lkX2tleSIgVU5JUVVFIENPTlNUUkFJTlQsIGJ0cmVlCihjdF9lbnRyeV9pZCwg Y2VydGlmaWNhdGVfaWQpDQpGb3JlaWduLWtleSBjb25zdHJhaW50czoNCiAgICAiY3RfZW50cnlf Y2hhaW5fY2VydGlmaWNhdGVfaWRfZmtleSIgRk9SRUlHTiBLRVkgKGNlcnRpZmljYXRlX2lkKQpS RUZFUkVOQ0VTIHJhd19jZXJ0aWZpY2F0ZXMoaWQpDQogICAgImN0X2VudHJ5X2NoYWluX2N0X2Vu dHJ5X2lkX2ZrZXkiIEZPUkVJR04gS0VZIChjdF9lbnRyeV9pZCkgUkVGRVJFTkNFUwpjdF9lbnRy eShpZCkNCg0KVGhpcyBoYXMgcmVzdWx0ZWQgaW4gMjA1IEdCIGJlaW5nIHJlYWQgZnJvbSBkaXNr LCBhbmQgOTMgR0IgYmVpbmcgd3JpdHRlbi4KV2hpbGUgSSBvbmx5IGV4cGVjdHMgNjYgR0IgdG8g YmUgcmV3cml0dGVuLg0KDQpMb29raW5nIGF0IHRoZSB2ZXJib3NlIG91dHB1dCBvZiB0aGUgdmFj dXVtLCBpdCBzZWVtcyB0aGF0IGl0IG5lZWRlZCB0byBzY2FuCnRoZSBpbmRleGVzIDQgdGltZXMu IFRoZSBhbW91bnQgb2YgZGF0YSByZWFkIGlzIGFib3V0IHdoYXQgSSBleHBlY3QuDQoNCkxvb2tp bmcgd2l0aCBzdHJhY2Ugd2hhdCBoYXBwZW5zLCBpdCBzZWVtcyB0aGF0IHRoZSBmaXJzdCB0aW1l IGl0IHJlYWRzIHRoZQpkYXRhLCBpdCBhbHNvIHdyaXRlcyBldmVyeXRoaW5nIGJhY2suIEkgYXNz dW1lIGl0IG1hcmtzIHRoZSByb3dzIGFzIGRlYWQuClRoZW4gd2hlbiBpbmRleGVzIGFyZSBjbGVh bmVkIHVwLCBpdCByZWFkcyt3cml0ZXMgdGhlIHdob2xlIHRhYmxlIGFnYWluLCB0bwphY3R1YWxs eSB2YWN1dW0gaXQuIENhbiB0aGF0IGZpcnN0IHdyaXRlIGJlIGF2b2lkZWQ/Cgo= --===============1632418204794812486==--