RE: unexpected result for wastedbytes query after vacuum full
Mike Schanne <[email protected]> Mon, 9 Dec 2019 23:06:52 +0000
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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==