Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fhJ8W-0008Q5-M9 for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Jul 2018 18:31:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fhJ8U-0007bO-4w for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Jul 2018 18:31:14 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fhJ8T-0007bF-Uy for pgsql-bugs@lists.postgresql.org; Sun, 22 Jul 2018 18:31:13 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fhJ8J-0000vf-Bk for pgsql-bugs@lists.postgresql.org; Sun, 22 Jul 2018 18:31:10 +0000 Content-Type: multipart/mixed; boundary="===============4971583358626233223==" MIME-Version: 1.0 Subject: BUG #15290: Stuck Parallel Index Scan query To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: vyegorov@gmail.com Reply-To: vyegorov@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 22 Jul 2018 18:30:29 +0000 Message-ID: <153228422922.1395.1746424054206154747@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4971583358626233223== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTI5MApMb2dnZWQgYnk6ICAgICAgICAgIFZpY3RvciBZZWdvcm92CkVt YWlsIGFkZHJlc3M6ICAgICAgdnllZ29yb3ZAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTAuNApPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiBHTlUvTGludXggOC43IChqZXNzaWUpCkRl c2NyaXB0aW9uOiAgICAgICAgCgpXZSd2ZSBqdXN0IGVuY291bnRlcmVkIGFuIGlzc3VlIG9uIHRo ZSBzdHJlYW1pbmcgcmVwbGljYSBvZiB0aGUgY2xpZW50Lg0KDQpJbiBzaG9ydCDigJTCoHF1ZXJ5 IGlzIGFjdGl2ZSBmb3IgOCBob3VycyBhbmQgd2UncmUgbm90IGFibGUgdG8gdGVybWluYXRlIGl0 OgphbGwgcHJvY2Vzc2VzIChsZWFkZXIgYW5kIHdvcmtlcnMpIGFyZSBpZ25vcmluZyBhbGwgc2ln bmFscy4NClN5bXB0b21zIGFyZSBzaW1pbGFyIHRvIHRoZSBvbmVzIGRlc2NyaWJlZCBpbiAjMTUw MzYuIEFzIGEgcmVzdWx0LCB3ZSBoYWQgdG8KcGVyZm9ybSBpbW1lZGlhdGUgc2h1dGRvd24gZiB0 aGUgaW5zdGFuY2UuDQpBZnRlciByZXN0YXJ0IHdlJ3ZlIGdvdCBhbm90aGVyIHN1Y2ggc3R1Y2sg cXVlcnkgd2l0aGluIG1pbnV0ZXMsIHNvIGl0J3Mgbm90CmEgc2luZ2xlIG9jY3VycmVuY2UuLg0K DQoNClF1ZXJ5IGluIHN1YmplY3QNCi0tLS0tLS0tLS0tLS0tLS0NCi1bIFJFQ09SRCAxCl0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KdHNfYWdlICAgICAgfCAw ODozMjoxNy4yODYzNDMNCnN0YXRlICAgICAgIHwgYWN0aXZlDQpxdWVyeV9hZ2UgICB8IDA4OjMy OjE3LjI4NjM0NQ0KY2hhbmdlX2FnZSAgfCAwODozMjoxNy4yODYzNDQNCmRhdG5hbWUgICAgIHwg Y291Yg0KcGlkICAgICAgICAgfCAyODc3DQp1c2VuYW1lICAgICB8IGFwcA0Kd2FpdGluZyAgICAg fCBmDQpjbGllbnRfYWRkciB8DQpjbGllbnRfcG9ydCB8IC0xDQpxdWVyeSAgICAgICB8IHNlbGVj dCBjb3VudCgqKSBhcyB2YWx1ZSBmcm9tIGNvdWJzIHdoZXJlIHR5cGU9J0NvdWI6OlNpbXBsZScK YW5kIGlzX2RvbmU9ZmFsc2UgYW5kIGluX3Byb2Nlc3M9ZmFsc2UNCg0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4N Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBGaW5hbGl6ZSBBZ2dyZWdhdGUgIChjb3N0PTY2NjAwMS42 Ny4uNjY2MDAxLjcyIHJvd3M9MSB3aWR0aD04KQ0KICAgLT4gIEdhdGhlciAgKGNvc3Q9NjY2MDAx LjIwLi42NjYwMDEuNjUgcm93cz04IHdpZHRoPTgpDQogICAgICAgICBXb3JrZXJzIFBsYW5uZWQ6 IDgNCiAgICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNvc3Q9NjY1OTAxLjIwLi42NjU5 MDEuMjUgcm93cz0xIHdpZHRoPTgpDQogICAgICAgICAgICAgICAtPiAgUGFyYWxsZWwgSW5kZXgg U2NhbiB1c2luZwpjb3Vic190eXBlX2lzX2RvbmVfcGFydGlhbF9zaW1wbGUgb24gY291YnMgIChj b3N0PTAuNTYuLjY2MzAxNi4wMQpyb3dzPTExNTQwNzcgd2lkdGg9MCkNCiAgICAgICAgICAgICAg ICAgICAgIEluZGV4IENvbmQ6IChpc19kb25lID0gZmFsc2UpDQogICAgICAgICAgICAgICAgICAg ICBGaWx0ZXI6ICgoTk9UIGlzX2RvbmUpIEFORCAoTk9UIGluX3Byb2Nlc3MpKQ0KKDcgcm93cykN Cg0KSW4gcmVhbGl0eSB0aGlzIHF1ZXJ5IHdvcmtlZCB3aXRoIGp1c3QgNCB3b3JrZXJzOg0KIDI4 NzcgPyAgICAgICAgdHMgICAgIDA6MDggIFxfIHBvc3RncmVzOiAxMC9tYWluOiBhcHAgY291YiBb bG9jYWxdIFNFTEVDVA0KIDM0MTYgPyAgICAgICAgU3MgICAgIDA6MDAgIFxfIHBvc3RncmVzOiAx MC9tYWluOiBiZ3dvcmtlcjogcGFyYWxsZWwgd29ya2VyCmZvciBQSUQgMjg3Nw0KIDM0MTcgPyAg ICAgICAgU3MgICAgIDA6MDAgIFxfIHBvc3RncmVzOiAxMC9tYWluOiBiZ3dvcmtlcjogcGFyYWxs ZWwgd29ya2VyCmZvciBQSUQgMjg3Nw0KIDM0MTggPyAgICAgICAgU3MgICAgIDA6MDAgIFxfIHBv c3RncmVzOiAxMC9tYWluOiBiZ3dvcmtlcjogcGFyYWxsZWwgd29ya2VyCmZvciBQSUQgMjg3Nw0K IDM0MTkgPyAgICAgICAgU3MgICAgIDA6MDAgIFxfIHBvc3RncmVzOiAxMC9tYWluOiBiZ3dvcmtl cjogcGFyYWxsZWwgd29ya2VyCmZvciBQSUQgMjg3Nw0KDQpXZSBoYXZlIGJhY2t0cmFjZXMgb2Yg dGhlIG1haW4gcHJvY2VzcyBhbmQgYWxsIHdvcmtlcnMsIGFuZCBhbHNvCmBwZ19zdGF0X2FjdGl2 aXR5YCBzbmFwc2hvdCDigJTCoEkgd2lsbCBhdHRhY2ggdGhlbSB0byB0aGUgbmV3IGUtbWFpbC4K Cg== --===============4971583358626233223==--