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.92) (envelope-from ) id 1j7HLo-0002KQ-Vl for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Feb 2020 11:29:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j7HLm-0005ct-Om for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Feb 2020 11:29:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j7HLm-0005b2-G5 for pgsql-bugs@lists.postgresql.org; Thu, 27 Feb 2020 11:29:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j7HLj-0002ty-Jy for pgsql-bugs@lists.postgresql.org; Thu, 27 Feb 2020 11:29:06 +0000 Content-Type: multipart/mixed; boundary="===============4519880718670493144==" MIME-Version: 1.0 Subject: BUG #16280: dead tuples (probably) effect plan and query performance To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: iserbin@bostonsd.ru Reply-To: iserbin@bostonsd.ru, pgsql-bugs@lists.postgresql.org Date: Thu, 27 Feb 2020 11:28:11 +0000 Message-ID: <16280-e393fbb744eae7aa@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4519880718670493144== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI4MApMb2dnZWQgYnk6ICAgICAgICAgIElseWEgU2VyYmluCkVtYWls IGFkZHJlc3M6ICAgICAgaXNlcmJpbkBib3N0b25zZC5ydQpQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjYKT3BlcmF0aW5nIHN5c3RlbTogICBDZW50b3MgNy40CkRlc2NyaXB0aW9uOiAgICAgICAgCgpI ZWxsbyBhbGwsDQpGYWNlZCBzb21lIHN0cmFuZ2UgcGxhbiBjaGFuZ2VzIHdpdGggYSBxdWVyeSAo cXVlcnkgaXMgcXVpdGUgYmFkLCBob3dldmVyIEkKY2FuJ3QgdW5kZXJzdGFuZCB3aHkgdGhlIHBs YW4gY2hhbmdlcykuDQpDb250ZXh0Og0KDQpkYjE9PiBcZCsgdGFibGUxDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZQoiZGIx LnRhYmxlMSINCiAgIENvbHVtbiAgIHwgICAgICAgICAgICBUeXBlICAgICAgICAgICAgIHwgQ29s bGF0aW9uIHwgTnVsbGFibGUgfCAgICAgICAgICAKICAgIERlZmF1bHQgICAgICAgICAgICAgICB8 IFN0b3JhZ2UgIHwgU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24NCi0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tDQogaWQgICAgICAgICB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8 ICAgICAgICAgICB8IG5vdCBudWxsIHwKbmV4dHZhbCgndGFibGUxX2lkX3NlcSc6OnJlZ2NsYXNz KSAgfCBwbGFpbiAgICB8ICAgICAgICAgICAgICB8DQogdGFibGUxX2lkICB8IGNoYXJhY3RlciB2 YXJ5aW5nKDI1NSkgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgICAgICAgICAgCiAgICAg ICAgICAgICAgICAgICAgICAgICAgfCBleHRlbmRlZCB8ICAgICAgICAgICAgICB8DQogY29udGVu dCAgICB8IGpzb25iICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAg IHwgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgfCBleHRlbmRlZCB8ICAgICAg ICAgICAgICB8DQogY3JlYXRlZF9hdCB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8ICAg ICAgICAgICB8IG5vdCBudWxsIHwgbm93KCkgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAg fCBwbGFpbiAgICB8ICAgICAgICAgICAgICB8DQogdXBkYXRlZF9hdCB8IHRpbWVzdGFtcCB3aXRo b3V0IHRpbWUgem9uZSB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgbm93KCkgICAgCiAgICAgICAg ICAgICAgICAgICAgICAgICAgfCBwbGFpbiAgICB8ICAgICAgICAgICAgICB8DQogcXVldWVkX2F0 ICB8IHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwg ICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgfCBwbGFpbiAgICB8ICAgICAgICAg ICAgICB8DQpJbmRleGVzOg0KICAgICJ0YWJsZTFfcGtleSIgUFJJTUFSWSBLRVksIGJ0cmVlIChp ZCkNCiAgICAidWtfdGFibGUxX2lkIiBVTklRVUUgQ09OU1RSQUlOVCwgYnRyZWUgKHRhYmxlMV9p ZCkNCiAgICAiY29udGVudF9pZHgiIGdpbiAoY29udGVudCBqc29uYl9wYXRoX29wcykNClJlZmVy ZW5jZWQgYnk6DQogICAgVEFCTEUgImNvbGxlY3Rpb25fdGFibGUxcyIgQ09OU1RSQUlOVCAiZmtf Y29sbGVjdGlvbl90YWJsZTFzX3RhYmxlMV9pZCIKRk9SRUlHTiBLRVkgKHRhYmxlMV9pZCkgUkVG RVJFTkNFUyB0YWJsZTEoaWQpDQogICAgVEFCTEUgImRiMV90YWJsZTFzIiBDT05TVFJBSU5UICJm a19kYjFfdGFibGUxc190YWJsZTFfaWQiIEZPUkVJR04gS0VZCih0YWJsZTFzX2lkKSBSRUZFUkVO Q0VTIHRhYmxlMShpZCkNCiAgICBUQUJMRSAidGFibGUxX3NvcnQiIENPTlNUUkFJTlQgImZrX3Rh YmxlMV9zb3J0X3RhYmxlMV9pZCIgRk9SRUlHTiBLRVkKKHRhYmxlMV9pZCkgUkVGRVJFTkNFUyB0 YWJsZTEodGFibGUxX2lkKQ0KICAgICAgICAgICAgICBuYW1lICAgICAgICAgICAgICB8ICBzZXR0 aW5nDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLQ0KIGNvbnN0 cmFpbnRfZXhjbHVzaW9uICAgICAgICAgICB8IHBhcnRpdGlvbg0KIGNwdV9pbmRleF90dXBsZV9j b3N0ICAgICAgICAgICB8IDAuMDA1DQogY3B1X29wZXJhdG9yX2Nvc3QgICAgICAgICAgICAgIHwg MC4wMDI1DQogY3B1X3R1cGxlX2Nvc3QgICAgICAgICAgICAgICAgIHwgMC4wMQ0KIGRlZmF1bHRf c3RhdGlzdGljc190YXJnZXQgICAgICB8IDIwMA0KIGVmZmVjdGl2ZV9jYWNoZV9zaXplICAgICAg ICAgICB8IDE1NzI4NjQNCiBlbmFibGVfYml0bWFwc2NhbiAgICAgICAgICAgICAgfCBvbg0KIGVu YWJsZV9oYXNoYWdnICAgICAgICAgICAgICAgICB8IG9uDQogZW5hYmxlX2hhc2hqb2luICAgICAg ICAgICAgICAgIHwgb24NCiBlbmFibGVfaW5kZXhvbmx5c2NhbiAgICAgICAgICAgfCBvbg0KIGVu YWJsZV9pbmRleHNjYW4gICAgICAgICAgICAgICB8IG9uDQogZW5hYmxlX21hdGVyaWFsICAgICAg ICAgICAgICAgIHwgb24NCiBlbmFibGVfbWVyZ2Vqb2luICAgICAgICAgICAgICAgfCBvbg0KIGVu YWJsZV9uZXN0bG9vcCAgICAgICAgICAgICAgICB8IG9uDQogZW5hYmxlX3BhcmFsbGVsX2FwcGVu ZCAgICAgICAgIHwgb24NCiBlbmFibGVfcGFyYWxsZWxfaGFzaCAgICAgICAgICAgfCBvbg0KIGVu YWJsZV9wYXJ0aXRpb25fcHJ1bmluZyAgICAgICB8IG9uDQogZW5hYmxlX3BhcnRpdGlvbndpc2Vf YWdncmVnYXRlIHwgb2ZmDQogZW5hYmxlX3BhcnRpdGlvbndpc2Vfam9pbiAgICAgIHwgb2ZmDQog ZW5hYmxlX3NlcXNjYW4gICAgICAgICAgICAgICAgIHwgb24NCiBlbmFibGVfc29ydCAgICAgICAg ICAgICAgICAgICAgfCBvbg0KIGVuYWJsZV90aWRzY2FuICAgICAgICAgICAgICAgICB8IG9uDQog cmFuZG9tX3BhZ2VfY29zdCAgICAgICAgICAgICAgIHwgMS4xDQogc2VxX3BhZ2VfY29zdCAgICAg ICAgICAgICAgICAgIHwgMQ0KIHNoYXJlZF9idWZmZXJzICAgICAgICAgICAgICAgICB8IDUyNDI4 OA0KKDI1IHJvd3MpDQoNCg0KRmlyc3QgcGxhbjogR29vZCBwbGFuIGFuZCBwcm9ibGVtYXRpYyBx dWVyeToKaHR0cHM6Ly9leHBsYWluLnRlbnNvci5ydS9hcmNoaXZlL2V4cGxhaW4vMWNmM2MwMTgx YTk1NzRiZjJmZDA2ZDZmZDA3ZGMyMDE6MDoyMDIwLTAyLTI3I2NvbnRleHQNClNlY29uZCBwbGFu OiBTYW1lIHF1ZXJ5IGFuZCBpdCdzIGJhZCBwbGFuOgpodHRwczovL2V4cGxhaW4udGVuc29yLnJ1 L2FyY2hpdmUvZXhwbGFpbi8zNzcwZDM5Zjc4NjEzNWUzOGJlYmViMWE4YTRiMWRhOTowOjIwMjAt MDItMjcjY29udGV4dA0KDQpJc3N1ZSBkZXNjcmlwdGlvbjoNCkFmdGVyIHNvbWUgbWluaW1hbCBh Y3Rpdml0eSBpbiBkYXRhYmFzZSBmaXJzdCBwbGFuIGNoYW5nZXMgdG8gdGhlIHNlY29uZC4KQW5h bHl6ZSBvbiB0YWJsZTEgZG8gbm90IGhlbHAgKHRyaWVkIHdpdGggdmFyaW91cyBkZWZhdWx0X3N0 YXRpc3RpY3NfdGFyZ2V0CnZhbHVlcykuDQpjb250ZW50X2lkeCBpbmRleCByZWNyZWF0aW9uIGhl bHBzIGZvciBzb21lIHRpbWUsIGJ1dCBzZXZlcmFsIG1pbnV0ZXMgbGF0ZXIKcGxhbiBkZWdyYWRl cyBiYWNrIHRvIHNlY29uZCBvbmUuDQpUaGUgb25seSB0aGluZyBoZWxwZWQgKHN1cnByaXNpbmds eSkgaXMgdmFjdXVtLiBJdCBhbHNvIGhlbHBzIGZvciBzb21lIHRpbWUsCmJ1dCBvbmNlIG51bWJl ciBvZiBkZWFkIHR1cGxlcyByZWFjaGVzIHNvbWV0aGluZyAgbGlrZSAzMDAtNTAwIC0gcGxhbgpj aGFuZ2VzIGJhY2sgdG8gc2Vjb25kIG9uZS4NCg0KVGFibGUgZGV0YWlscyB3aXRoIGJhZCBwbGFu Og0KDQpkYjE9PiBzZWxlY3QgKiBmcm9tIHBnX3N0YXRfdXNlcl90YWJsZXMgd2hlcmUgcmVsbmFt ZT0ndGFibGUxJzsNCi1bIFJFQ09SRCAxIF0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KcmVsaWQgICAgICAgICAgICAgICB8IDc0ODEzNTk4DQpzY2hlbWFuYW1lICAgICAg ICAgIHwgZGIxDQpyZWxuYW1lICAgICAgICAgICAgIHwgdGFibGUxDQpzZXFfc2NhbiAgICAgICAg ICAgIHwgMTE2Nw0Kc2VxX3R1cF9yZWFkICAgICAgICB8IDMxNTE1ODcxOA0KaWR4X3NjYW4gICAg ICAgICAgICB8IDIzMTE2NTM2DQppZHhfdHVwX2ZldGNoICAgICAgIHwgNDIzNTM3NzgNCm5fdHVw X2lucyAgICAgICAgICAgfCA0MDkyODgNCm5fdHVwX3VwZCAgICAgICAgICAgfCAzMTMxMTQ5NjMN Cm5fdHVwX2RlbCAgICAgICAgICAgfCAwDQpuX3R1cF9ob3RfdXBkICAgICAgIHwgNDY4Mw0Kbl9s aXZlX3R1cCAgICAgICAgICB8IDQwOTI4OA0Kbl9kZWFkX3R1cCAgICAgICAgICB8IDM3OQ0Kbl9t b2Rfc2luY2VfYW5hbHl6ZSB8IDExNjkNCmxhc3RfdmFjdXVtICAgICAgICAgfCAyMDIwLTAyLTEy IDA4OjU4OjA2LjE0NzI0NyswMQ0KbGFzdF9hdXRvdmFjdXVtICAgICB8IDIwMjAtMDItMjAgMTI6 Mjk6MzEuNDI3MDgyKzAxDQpsYXN0X2FuYWx5emUgICAgICAgIHwNCmxhc3RfYXV0b2FuYWx5emUg ICAgfCAyMDIwLTAyLTIwIDEwOjEyOjExLjQ5NDMwNSswMQ0KdmFjdXVtX2NvdW50ICAgICAgICB8 IDINCmF1dG92YWN1dW1fY291bnQgICAgfCA3MDINCmFuYWx5emVfY291bnQgICAgICAgfCAwDQph dXRvYW5hbHl6ZV9jb3VudCAgIHwgMjANCg0KVGFibGUgZGV0YWlscyB3aXRoIGdvb2QgcGxhbiBh ZnRlciB2YWN1dW06DQotWyBSRUNPUkQgMSBdLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCnJlbGlkICAgICAgICAgICAgICAgfCA3NDgxMzU5OA0Kc2NoZW1hbmFtZSAgICAg ICAgICB8IGRiMQ0KcmVsbmFtZSAgICAgICAgICAgICB8IHRhYmxlMQ0Kc2VxX3NjYW4gICAgICAg ICAgICB8IDExNjcNCnNlcV90dXBfcmVhZCAgICAgICAgfCAzMTUxNTg3MTgNCmlkeF9zY2FuICAg ICAgICAgICAgfCAyMzExNjY2Mg0KaWR4X3R1cF9mZXRjaCAgICAgICB8IDQyMzYwNjk0DQpuX3R1 cF9pbnMgICAgICAgICAgIHwgNDA5Mjg4DQpuX3R1cF91cGQgICAgICAgICAgIHwgMzEzMTE0OTYz DQpuX3R1cF9kZWwgICAgICAgICAgIHwgMA0Kbl90dXBfaG90X3VwZCAgICAgICB8IDQ2ODMNCm5f bGl2ZV90dXAgICAgICAgICAgfCA0MDkyODgNCm5fZGVhZF90dXAgICAgICAgICAgfCAwDQpuX21v ZF9zaW5jZV9hbmFseXplIHwgMA0KbGFzdF92YWN1dW0gICAgICAgICB8IDIwMjAtMDItMjYgMDg6 MTA6NDkuODg0NjI1KzAxDQpsYXN0X2F1dG92YWN1dW0gICAgIHwgMjAyMC0wMi0yMCAxMjoyOToz MS40MjcwODIrMDENCmxhc3RfYW5hbHl6ZSAgICAgICAgfCAyMDIwLTAyLTI2IDA4OjEzOjA3LjI1 MzMwNyswMQ0KbGFzdF9hdXRvYW5hbHl6ZSAgICB8IDIwMjAtMDItMjAgMTA6MTI6MTEuNDk0MzA1 KzAxDQp2YWN1dW1fY291bnQgICAgICAgIHwgMw0KYXV0b3ZhY3V1bV9jb3VudCAgICB8IDcwMg0K YW5hbHl6ZV9jb3VudCAgICAgICB8IDENCmF1dG9hbmFseXplX2NvdW50ICAgfCAyMA0KDQpJIGNh biBjb25maXJtIHRoYXQgaXNzdWUgZXhpc3RzIG9uIDExLjQgYW5kIDExLjYgKHVwZGF0ZWQgdG8g MTEuNiBzaW5jZSBJCnRob3VnaHQgaXQgd2FzIGEgYnUgdGhhdCBtYXkgaGF2ZSBiZWVuIGZpeGVk IGluIDExLjUgIkZpeCBwb3NzaWJsZSBmYWlsdXJlCm9mIHBsYW5uZXIncyBpbmRleCBlbmRwb2lu dCBwcm9iZXMgKFRvbSBMYW5lKSIpLCBpdCBpcyBhbHdheXMgcmVwcm9kdWNpYmxlLAphbmQgY2Fu IGJlIHJlcHJvZHVjdGVkIG9uIHByb2QgYW5kIGFsbCBsb3dlciBlbnZpcm9ubWVudHMuDQpJIGNh bid0IHVuZGVyc3RhbmQgd2h5IGl0IGhhcHBlbnMuIEFzIGZhciBhcyBJIHVuZGVyc3RhbmQgdGhl cmUgaXMgc29tZXRoaW5nCnRvIGRvIHdpdGggdmlzaWJpbGl0eSBtYXAsIGJ1dCBhcyBwZXIgZG9j dW1lbnRpb24gaXQgc2hvdWxkIGVmZmVjdAppbmRleC1vbmx5IHNjYW5zLCBub3QgbXkgY2FzZS4N Ck1haW4gdHdvIHF1ZXN0aW9ucyBhcmU6DQoxKSBJcyBpdCBhIGJ1Zz8NCjIpIElmIGl0IGlzIGV4 cGVjdGVkIGJlaGF2aW91ciAtIGNhbiBzb21lb25lIHBsZWFzZSBleHBsYWluIHdoeSBpdCBoYXBw ZW5zCmFuZCBpZiB0aGVyZSBpcyBhbnkgd2F5ICB0byBrZWVwIHRoZSBnb29kIHBsYW4gKHdpdGhv dXQgaW5zdGFsbGluZwpleHRlbnNpb25zIHRvIGZvcmNlIHBpbiBwbGFucykNCg0KQmVzdCByZWdh cmRzLCANCklseWEKCg== --===============4519880718670493144==--