Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ieS7L-0006y9-Mz for pgsql-performance@arkaria.postgresql.org; Mon, 09 Dec 2019 23:07:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ieS7K-0006j9-Fk for pgsql-performance@arkaria.postgresql.org; Mon, 09 Dec 2019 23:07:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ieS7K-0006im-2a for pgsql-performance@lists.postgresql.org; Mon, 09 Dec 2019 23:07:02 +0000 Received: from mails2.kns.com ([199.171.180.12]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ieS7G-0002EW-Np for pgsql-performance@postgresql.org; Mon, 09 Dec 2019 23:07:00 +0000 X-ASG-Debug-ID: 1575932816-0a96b771ec1c6360001-c4zXsc Received: from USEPRDEX1.corp.kns.com (useprdex1.corp.kns.com [10.40.10.30]) by mails2.kns.com with ESMTP id VRM7w6iCQ9lNKZGg; Mon, 09 Dec 2019 18:06:56 -0500 (EST) X-Barracuda-Envelope-From: mschanne@kns.com Received: from USEPRDEX1.corp.kns.com (10.40.10.30) by USEPRDEX1.corp.kns.com (10.40.10.30) with Microsoft SMTP Server (TLS) id 15.0.1263.5; Mon, 9 Dec 2019 18:06:53 -0500 Received: from USEPRDEX1.corp.kns.com ([fe80::8902:ecdb:4dc3:cfac]) by USEPRDEX1.corp.kns.com ([fe80::8902:ecdb:4dc3:cfac%22]) with mapi id 15.00.1263.000; Mon, 9 Dec 2019 18:06:53 -0500 From: Mike Schanne To: 'Justin Pryzby' CC: "'pgsql-performance@postgresql.org'" Subject: RE: unexpected result for wastedbytes query after vacuum full Thread-Topic: unexpected result for wastedbytes query after vacuum full X-ASG-Orig-Subj: RE: unexpected result for wastedbytes query after vacuum full Thread-Index: AQHVrIzphvrkp70cRVmKqtyS5vftoaeycUsQ Date: Mon, 9 Dec 2019 23:06:52 +0000 Message-ID: <1dfe6231d70545a7a7136bb8dd7265b9@USEPRDEX1.corp.kns.com> References: <20191206232849.GT2082@telsasoft.com> In-Reply-To: <20191206232849.GT2082@telsasoft.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.40.22.174] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Barracuda-Connect: useprdex1.corp.kns.com[10.40.10.30] X-Barracuda-Start-Time: 1575932816 X-Barracuda-URL: https://Mails2.kns.com:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at kns.com X-Barracuda-Scan-Msg-Size: 1849 X-Barracuda-BRTS-Status: 1 X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=1000.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.3.78560 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk WWVzLCB0aGUgYWRkaXRpb25hbCBiaXRtYXAgY291bGQgY2VydGFpbmx5IGV4cGxhaW4gdGhlIGlu Y3JlYXNlLg0KDQpUaGFua3MsDQpNaWtlDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpG cm9tOiBKdXN0aW4gUHJ5emJ5IFttYWlsdG86cHJ5emJ5QHRlbHNhc29mdC5jb21dDQpTZW50OiBG cmlkYXksIERlY2VtYmVyIDA2LCAyMDE5IDY6MjkgUE0NClRvOiBNaWtlIFNjaGFubmUNCkNjOiBw Z3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6IHVuZXhwZWN0ZWQg cmVzdWx0IGZvciB3YXN0ZWRieXRlcyBxdWVyeSBhZnRlciB2YWN1dW0gZnVsbA0KDQpPbiBGcmks IERlYyAwNiwgMjAxOSBhdCAwNToxODoyMFBNICswMDAwLCBNaWtlIFNjaGFubmUgd3JvdGU6DQo+ IEhpIGFsbCwNCj4NCj4gVGhpcyBxdWVzdGlvbiBpcyBzb21ld2hhdCByZWxhdGVkIHRvIG15IHBy ZXZpb3VzIHF1ZXN0aW9uOg0KPiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlk LzA4NzFmY2YzNWNlYjRjYWE4YTIyMDRjYTljMzhlMzMwJTQwVVNFUFJERVgxLmNvcnAua25zLmNv bQ0KPg0KPiBJIHdhcyBhdHRlbXB0aW5nIHRvIG1lYXN1cmUgdGhlIGJlbmVmaXQgb2YgZG9pbmcg YSBWQUNVVU0gRlVMTCBvbiBteSBkYXRhYmFzZS4gIEkgd2FzIHVzaW5nIHRoZSBxdWVyeSBmb3Vu ZCBoZXJlOg0KPiBodHRwczovL3dpa2kucG9zdGdyZXNxbC5vcmcvd2lraS9TaG93X2RhdGFiYXNl X2Jsb2F0DQo+DQo+IEhvd2V2ZXIsIEkgZ290IGFuIHVuZXhwZWN0ZWQgcmVzdWx0IGluIHRoYXQg dGhlICJ3YXN0ZWRieXRlcyIgdmFsdWUgYWN0dWFsbHkgaW5jcmVhc2VkIGZvciBzb21lIHRhYmxl cyBhZnRlciBkb2luZyB0aGUgdmFjdXVtLg0KDQo+IEkgd2FzIHdvbmRlcmluZyBpZiB0aGUgZmFj dCB0aGF0IHdlIHVzZSBhIGpzb24gY29sdW1uIGNvdWxkIGJlIGludGVyZmVyaW5nIHdpdGggdGhl IHdhc3RlZGJ5dGVzIGNhbGN1bGF0aW9uLiAgQ2FuIGFueW9uZSBleHBsYWluIGhvdyB3YXN0ZWRi eXRlcyBjb3VsZCBpbmNyZWFzZSBmcm9tIGEgdmFjdXVtPw0KDQpJcyBpdCBkdWUgdG8gZHJvcHBl ZCBjb2x1bW5zLCBsaWtlIFRvbSBleHBsYWluZWQgaGVyZSA/DQpodHRwczovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9tZXNzYWdlLWlkLzE4Mzc1LjE1MjA3MjM5NzElNDBzc3MucGdoLnBhLnVzDQoNCl9f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoNClRoaXMgZW1haWwgaXMgbm9uLWJpbmRp bmcsIGlzIHN1YmplY3QgdG8gY29udHJhY3QsIGFuZCBuZWl0aGVyIEt1bGlja2UgYW5kIFNvZmZh IEluZHVzdHJpZXMsIEluYy4gbm9yIGl0cyBzdWJzaWRpYXJpZXMgKGVhY2ggYW5kIGNvbGxlY3Rp dmVseSDigJxLJlPigJ0pIHNoYWxsIGhhdmUgYW55IG9ibGlnYXRpb24gdG8geW91IHRvIGNvbnN1 bW1hdGUgdGhlIHRyYW5zYWN0aW9ucyBoZXJlaW4gb3IgdG8gZW50ZXIgaW50byBhbnkgYWdyZWVt ZW50LCBvdGhlciB0aGFuIGluIGFjY29yZGFuY2Ugd2l0aCB0aGUgdGVybXMgYW5kIGNvbmRpdGlv bnMgb2YgYSBkZWZpbml0aXZlIGFncmVlbWVudCBpZiBhbmQgd2hlbiBuZWdvdGlhdGVkLCBmaW5h bGl6ZWQgYW5kIGV4ZWN1dGVkIGJldHdlZW4gdGhlIHBhcnRpZXMuIFRoaXMgZW1haWwgYW5kIGFs bCBpdHMgY29udGVudHMgYXJlIHByb3RlY3RlZCBieSBJbnRlcm5hdGlvbmFsIGFuZCBVbml0ZWQg U3RhdGVzIGNvcHlyaWdodCBsYXdzLiBBbnkgcmVwcm9kdWN0aW9uIG9yIHVzZSBvZiBhbGwgb3Ig YW55IHBhcnQgb2YgdGhpcyBlbWFpbCB3aXRob3V0IHRoZSBleHByZXNzIHdyaXR0ZW4gY29uc2Vu dCBvZiBLJlMgaXMgcHJvaGliaXRlZC4NCg==