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 1ipq8M-0005G0-MG for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Jan 2020 08:59:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ipq8L-0002Pu-6F for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Jan 2020 08:59:09 +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 1ipq8K-0002OD-U9 for pgsql-bugs@lists.postgresql.org; Fri, 10 Jan 2020 08:59:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ipq8H-0003kD-BQ for pgsql-bugs@lists.postgresql.org; Fri, 10 Jan 2020 08:59:08 +0000 Content-Type: multipart/mixed; boundary="===============8385105865641003966==" MIME-Version: 1.0 Subject: BUG #16201: Second column in Range Partition is scanning all the partitions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rahulsaha0309@gmail.com Reply-To: rahulsaha0309@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 10 Jan 2020 08:58:23 +0000 Message-ID: <16201-c3c89cdee7215e9f@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8385105865641003966== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjIwMQpMb2dnZWQgYnk6ICAgICAgICAgIFJhaHVsIFNhaGEKRW1haWwg YWRkcmVzczogICAgICByYWh1bHNhaGEwMzA5QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEwLjUKT3BlcmF0aW5nIHN5c3RlbTogICBBbWF6b24gTGludXgKRGVzY3JpcHRpb246ICAgICAg ICAKCkhpIFBnIFRlYW0sDQoNCkkgd2FzIHdvcmtpbmcgb24gUGFydGl0aW9ucyBvbiB2ZXJzaW9u IDEwLjUgYW5kIEkgYW0gbm90IGFibGUgdG8gdW5kZXJzdGFuZAp0aGlzIGJlaGF2aW91ciwgY291 bGQgeW91IHBsZWFzZSBzaGFyZSB5b3VyIGNvbW1lbnRzLg0KDQpJIGNyZWF0ZWQgcmFuZ2UgcGFy dGl0aW9ucyBvbiB0d28gY29sdW1ucyBhbmQgd2hlbiBJIHRyeSB0byBzZWUgZXhwbGFpbiBwbGFu CmZvciBjb2x1bW4gYiBhcyB3aGVyZSBjb25kaXRpb25zLCBpdCBkb2VzIHNjYW5uaW5nIG9uIGFs bCB0aGUgcGFydGl0aW9ucy4gSXMKaXQgZXhwZWN0ZWQgYmVoYXZpb3VyIG9yIHRoaXMgaXMgYSBi dWcuIFBsZWFzZSBmaW5kIGJlbG93IHRoZSBzdGVwcyAtIA0KDQpQRyBWZXJzaW9uIDEwLjUgLQ0K DQpDcmVhdGUgUGFyZW50IFRhYmxlOg0KPT09PT09PT09PT09PT09PQ0KQ1JFQVRFIFRBQkxFIHNh bGVzMw0KKA0KICBkZXB0X25vICAgICBpbnQsDQogIHNhbGVfeWVhciAgICBpbnQsDQogIHNhbGVf bW9udGggICBpbnQsDQogIHNhbGVfZGF5ICAgICBpbnQsDQogIGFtb3VudCAgICAgIGludA0KKQ0K UEFSVElUSU9OIEJZIFJBTkdFKHNhbGVfeWVhciwgc2FsZV9tb250aCk7DQoNCkNyZWF0ZSBQYXJ0 aXRpb24vQ2hpbGQgVGFibGU6DQo9PT09PT09PT09PT09PT09PT09PT09PT0NCmNyZWF0ZSB0YWJs ZSBjaGlsZDEgcGFydGl0aW9uIG9mIHNhbGVzMyBmb3IgdmFsdWVzIGZyb20gKCcyMDAwJywnNCcp IHRvCignMjAxMCcsJzcnKTsNCg0KY3JlYXRlIHRhYmxlIGNoaWxkMiBwYXJ0aXRpb24gb2Ygc2Fs ZXMzIGZvciB2YWx1ZXMgZnJvbSAoJzIwMTEnLCc4JykgdG8KKCcyMDIwJywnMTInKTsNCg0KY3Jl YXRlIHRhYmxlIGNoaWxkMyAgcGFydGl0aW9uIG9mIHNhbGVzMyBmb3IgdmFsdWVzIGZyb20gKCcy MDIxJywnMTMnKSB0bwooJzIwMjMnLCcxNicpOw0KDQpjcmVhdGUgdGFibGUgY2hpbGQ0ICBwYXJ0 aXRpb24gb2Ygc2FsZXMzIGZvciB2YWx1ZXMgZnJvbSAoJzIwMjEnLCcxNycpIHRvCignMjAyMycs JzEwMDAnKTsNCg0KRXhwbGFpbiBwbGFucyAgd2l0aCBjb2x1bW4gQQ0KPT09PT09PT09PT09PT09 PT09PT09PT0NCnBvc3RncmVzPT4gZXhwbGFpbiBzZWxlY3QgKiBmcm9tIHNhbGVzMyB3aGVyZSBz YWxlX3llYXI9JzIwMDEnOw0KICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAg ICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogQXBwZW5kICAoY29zdD0wLjAwLi4zMS4y NSByb3dzPTggd2lkdGg9MjApDQogICAtPiAgU2VxIFNjYW4gb24gY2hpbGQxICAoY29zdD0wLjAw Li4zMS4yNSByb3dzPTggd2lkdGg9MjApDQogICAgICAgICBGaWx0ZXI6IChzYWxlX3llYXIgPSAy MDAxKQ0KKDMgcm93cykNCg0KRXhwbGFpbiBwbGFucyAgd2l0aCBjb2x1bW4gQSAmIEINCj09PT09 PT09PT09PT09PT09PT09PT09PT09DQoNCnBvc3RncmVzPT4gZXhwbGFpbiBzZWxlY3QgKiBmcm9t IHNhbGVzMyB3aGVyZSBzYWxlX3llYXI9JzIwMDEnIGFuZApzYWxlX21vbnRoPSc1JzsNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAgICAgICAgICAgICAg DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIEFwcGVuZCAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93cz0xIHdpZHRoPTIwKQ0KICAg LT4gIFNlcSBTY2FuIG9uIGNoaWxkMSAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93cz0xIHdpZHRoPTIw KQ0KICAgICAgICAgRmlsdGVyOiAoKHNhbGVfeWVhciA9IDIwMDEpIEFORCAoc2FsZV9tb250aCA9 IDUpKQ0KKDMgcm93cykNCg0KRXhwbGFpbiBwbGFucyAgd2l0aCBjb2x1bW4gQg0KPT09PT09PT09 PT09PT09PT09PT09PT0NCg0KcG9zdGdyZXM9PiBleHBsYWluIHNlbGVjdCAqIGZyb20gc2FsZXMz IHdoZXJlICBzYWxlX21vbnRoPSc5JzsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkg UExBTiAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEFwcGVuZCAgKGNvc3Q9MC4w MC4uNjIuNTAgcm93cz0xNiB3aWR0aD0yMCkNCiAgIC0+ICBTZXEgU2NhbiBvbiBjaGlsZDEgIChj b3N0PTAuMDAuLjMxLjI1IHJvd3M9OCB3aWR0aD0yMCkNCiAgICAgICAgIEZpbHRlcjogKHNhbGVf bW9udGggPSA5KQ0KICAgLT4gIFNlcSBTY2FuIG9uIGNoaWxkMiAgKGNvc3Q9MC4wMC4uMzEuMjUg cm93cz04IHdpZHRoPTIwKQ0KICAgICAgICAgRmlsdGVyOiAoc2FsZV9tb250aCA9IDkpIA0KKDUg cm93cykNCg0KSWYgeW91IHNlZSB0aGUgbGFzdCBFeHBsYWluIHBsYW4sIGl0IGlzIHNjYW5uaW5n IGJvdGggIHRoZSBjaGlsZCB0YWJsZS4gSXMKaXQgZXhwZWN0ZWQgYmVoYXZpb3VyLCBpZiB5ZXMg Y2FuIHlvdSBwbGVhc2UgaGVscCBtZSB1bmRlcnN0YW5kIHRoYXQgPwoK --===============8385105865641003966==--