Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dlH9t-0004cS-JH for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 16:08:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dlH9t-0000Hp-1P for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 16:08:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dlH9r-0000Fl-MO for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 16:08:31 +0000 Received: from smtp88.ord1c.emailsrvr.com ([108.166.43.88]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dlH9o-0005QR-DA for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 16:08:30 +0000 Received: from smtp20.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp20.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id AA717E031C; Fri, 25 Aug 2017 12:08:20 -0400 (EDT) Received: from smtp192.mex05.mlsrvr.com (unknown [184.106.31.85]) by smtp20.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTPS id 92520E01A7; Fri, 25 Aug 2017 12:08:20 -0400 (EDT) X-Sender-Id: anikob@spiceworks.com Received: from smtp192.mex05.mlsrvr.com ([UNAVAILABLE]. [184.106.31.85]) (using TLSv1 with cipher DHE-RSA-AES256-SHA) by 0.0.0.0:25 (trex/5.7.12); Fri, 25 Aug 2017 12:08:20 -0400 Received: from ORD2MBX13A.mex05.mlsrvr.com ([fe80::58b4:20ff:fe52:4153]) by ORD2HUB11.mex05.mlsrvr.com ([fe80::d6ae:52ff:fe7f:65d8%15]) with mapi id 14.03.0279.002; Fri, 25 Aug 2017 11:08:20 -0500 From: Aniko Belim To: Justin Pryzby CC: "pgsql-performance@postgresql.org" Subject: Re: Partitioned table - scans through every partitions Thread-Topic: [PERFORM] Partitioned table - scans through every partitions Thread-Index: AQHTHbfr1rkno18Nbku9JrK/13urJaKVinoA//+y0AA= Date: Fri, 25 Aug 2017 16:08:19 +0000 Message-ID: References: <6EB8CBFC-49E5-4745-96D8-532EC912D039@spiceworks.com> <20170825154434.GC16287@telsasoft.com> In-Reply-To: <20170825154434.GC16287@telsasoft.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [67.198.47.100] Content-Type: text/plain; charset="utf-8" Content-ID: <57BD88CE8E06174BBA8C045F4D551D68@mex05.mlsrvr.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org VGhhbmsgeW91LCBKdXN0aW4hICANCg0KQW5pa28NCg0KDQoNCg0KT24gOC8y NS8xNywgMTA6NDQgQU0sICJKdXN0aW4gUHJ5emJ5IiA8cHJ5emJ5QHRlbHNh c29mdC5jb20+IHdyb3RlOg0KDQo+T24gRnJpLCBBdWcgMjUsIDIwMTcgYXQg MDM6MzY6MjlQTSArMDAwMCwgQW5pa28gQmVsaW0gd3JvdGU6DQo+PiBIaSwN Cj4+IA0KPj4gV2UgaGF2ZSBhbiBpc3N1ZSB3aXRoIG9uZSBvZiBvdXIgcGFy dGl0aW9uZWQgdGFibGVzLiBJdCBoYXMgYSBjb2x1bW4gd2l0aCB0aW1lc3Rh bXAgd2l0aG91dCB0aW1lIHpvbmUgdHlwZSwgYW5kIHdlIGhhZCB0byBwYXJ0 aXRpb24gaXQgZGFpbHkuIFRvIGRvIHRoYXQsIHdlIGNyZWF0ZWQgdGhlIGZv bGxvd2luZyBjb25zdHJhaW50cyBsaWtlIHRoaXMgZXhhbXBsZToNCj4+IENI RUNLICh0b19jaGFyKGltcHJlc3Npb25fdGltZSwgJ1lZWVlNTUREJzo6dGV4 dCkgPSAnMjAxNzAyMDInOjp0ZXh0KQ0KPj4gDQo+PiANCj4+IFRoZSBwcm9i bGVtIHdl4oCZcmUgZmFjaW5nIGlzIG5vIG1hdHRlciBob3cgd2XigJlyZSB0 cnlpbmcgdG8gc2VsZWN0IGZyb20gaXQsIGl0IHNjYW5zIHRocm91Z2ggZXZl cnkgcGFydGl0aW9ucy4NCj4NCj4NCj4+IEl0IHNjYW5zIHRocm91Z2ggZXZl cnkgcGFydGl0aW9ucy4gU2hvdWxkbuKAmXQgaXQgb25seSBzY2FuIHRoZSBk ZnBfaW5fbmV0d29ya19pbXByZXNzaW9ucy5kZnBfaW5fbmV0d29ya19pbXBy ZXNzaW9uc18yMDE3MDIwMiBjaGlsZCB0YWJsZT8gT3Igd2UgbWlzc2luZyBz b21ldGhpbmc/DQo+PiBBbnkgYWR2aWNlL2hlbHAgd291bGQgaGlnaGx5IGFw cHJlY2lhdGVkLg0KPg0KPmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2Rv Y3MvOS42L3N0YXRpYy9kZGwtcGFydGl0aW9uaW5nLmh0bWwjRERMLVBBUlRJ VElPTklORy1DQVZFQVRTDQo+fFRoZSBmb2xsb3dpbmcgY2F2ZWF0cyBhcHBs eSB0byBjb25zdHJhaW50IGV4Y2x1c2lvbjoNCj58ICAgIENvbnN0cmFpbnQg ZXhjbHVzaW9uIG9ubHkgd29ya3Mgd2hlbiB0aGUgcXVlcnkncyBXSEVSRSBj bGF1c2UgY29udGFpbnMNCj58ICAgIGNvbnN0YW50cyAob3IgZXh0ZXJuYWxs eSBzdXBwbGllZCBwYXJhbWV0ZXJzKS4gRm9yIGV4YW1wbGUsIGEgY29tcGFy aXNvbg0KPnwgICAgYWdhaW5zdCBhIG5vbi1pbW11dGFibGUgZnVuY3Rpb24g c3VjaCBhcyBDVVJSRU5UX1RJTUVTVEFNUCBjYW5ub3QgYmUNCj58ICAgIG9w dGltaXplZCwgc2luY2UgdGhlIHBsYW5uZXIgY2Fubm90IGtub3cgd2hpY2gg cGFydGl0aW9uIHRoZSBmdW5jdGlvbiB2YWx1ZQ0KPnwgICAgbWlnaHQgZmFs bCBpbnRvIGF0IHJ1biB0aW1lLg0KPg0KPi4uLg0KCi0tIApTZW50IHZpYSBw Z3NxbC1wZXJmb3JtYW5jZSBtYWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1h bmNlQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBz dWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHBy ZWYvcGdzcWwtcGVyZm9ybWFuY2UK