Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c6hUH-00057z-CK for pgsql-performance@arkaria.postgresql.org; Tue, 15 Nov 2016 17:25:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c6hUG-0007YR-V3 for pgsql-performance@arkaria.postgresql.org; Tue, 15 Nov 2016 17:25:37 +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.84_2) (envelope-from ) id 1c6hUF-0007XT-PU for pgsql-performance@postgresql.org; Tue, 15 Nov 2016 17:25:35 +0000 Received: from gproxy9-pub.mail.unifiedlayer.com ([69.89.20.122]) by magus.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c6hU8-0003xt-Me for pgsql-performance@postgresql.org; Tue, 15 Nov 2016 17:25:35 +0000 Received: (qmail 8409 invoked by uid 0); 15 Nov 2016 17:25:22 -0000 Received: from unknown (HELO cmgw4) (10.0.90.85) by gproxy9.mail.unifiedlayer.com with SMTP; 15 Nov 2016 17:25:22 -0000 Received: from box1242.bluehost.com ([50.87.248.242]) by cmgw4 with id 8HQp1u00J5EY2ei01HQsh9; Tue, 15 Nov 2016 10:24:53 -0700 X-Authority-Analysis: v=2.1 cv=Zpp+dbLG c=1 sm=1 tr=0 a=N7MoqGMa2tvd8AqN2pi9kA==:117 a=N7MoqGMa2tvd8AqN2pi9kA==:17 a=L9H7d07YOLsA:10 a=9cW_t1CCXrUA:10 a=s5jvgZ67dGcA:10 a=IkcTkHD0fZMA:10 a=L24OOQBejmoA:10 a=CSwD4DPDAAAA:8 a=epTmVMiNAAAA:8 a=ijQYoh1vUBxVOZQY__oA:9 a=3YAXn6lbn1Ubzz1o:21 a=QEXdDO2ut3YA:10 a=jFnZSrNcIxrrcW8ogBOp:22 a=ndEWmUVY6Yapc0oHF_P4:22 Received: from c83-250-54-236.bredband.comhem.se ([83.250.54.236]:36749 helo=[192.168.1.109]) by box1242.bluehost.com with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.86_1) (envelope-from ) id 1c6hTU-0000Lp-Di; Tue, 15 Nov 2016 10:24:49 -0700 Date: Tue, 15 Nov 2016 20:23:38 +0300 Subject: Re: Sql Query :: Any advice ? Message-ID: <5g3op8erm4gl7jq93fme2v4m.1479230618890@email.android.com> From: Henrik To: vinny@xs4all.nl Cc: pgsql-performance , pgsql-performance-owner@postgresql.org References: <1fd2cd0b983d53719d7a0f50855303a6@xs4all.nl> MIME-Version: 1.0 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - box1242.bluehost.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - ekenberg.pw X-BWhitelist: no X-Source-IP: 83.250.54.236 X-Exim-ID: 1c6hTU-0000Lp-Di X-Source: X-Source-Args: X-Source-Dir: X-Source-Sender: c83-250-54-236.bredband.comhem.se ([192.168.1.109]) [83.250.54.236]:36749 X-Source-Auth: henrik@ekenberg.pw X-Email-Count: 5 X-Source-Cap: Y3VycmVuZzE7Y3VycmVuZzE7Ym94MTI0Mi5ibHVlaG9zdC5jb20= X-Pg-Spam-Score: -0.3 (/) 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 PGRpdiBkaXI9Imx0ciI+SGksIDxicj4KPC9kaXY+PGRpdiBkaXI9Imx0ciI+PGJyPgo8L2Rpdj48 ZGl2IGRpcj0ibHRyIj5Gb3JleCBhbmQgb3B0aW9ucyBhcmUgaW7CoCB0cmFkZXMgdGFibGU8YnI+ CjwvZGl2PjxkaXYgZGlyPSJsdHIiPjxicj4KPC9kaXY+PGRpdiBkaXI9Imx0ciI+QmVzdCByZWdh cmRzIDxicj4KPC9kaXY+PGRpdiBkaXI9Imx0ciI+SGVucmlrIDxicj4KPC9kaXY+PGRpdiBkaXI9 Imx0ciI+PGJyPgo8L2Rpdj48ZGl2IGRpcj0ibHRyIj48YnI+CjwvZGl2PjxkaXYgZGlyPSJsdHIi Pjxicj4KPC9kaXY+PGRpdiBjbGFzcz0id3BzX3NpZ25hdHVyZSI+U2VudCBmcm9tIG15IE1pIHBh ZDwvZGl2PjxkaXYgY2xhc3M9Indwc19xdW90aW9uIj5PbiB2aW5ueSAmbHQ7dmlubnlAeHM0YWxs Lm5sJmd0OywgTm92IDE1LCAyMDE2IDY6NDYgUE0gd3JvdGU6PGJyIHR5cGU9ImF0dHJpYnV0aW9u Ij48YmxvY2txdW90ZSBjbGFzcz0icXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhleDtib3Jk ZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij48cD48L3A+PHAgZGlyPSJs dHIiPkFyZSB0aGUgZm9yZXggYW5kIG9wdGlvbnMgaW4gdGhlIGhpc3RfYWNjb3VudF9iYWxhbmNl IHRhYmxlPw08YnI+ClRoZSBzZXF1ZW50aWFsIHNjYW4gaXMgb24gdGhhdCB0YWJsZSBzbyBpZiB0 aGV5IGFyZSwNPGJyPgpzbyBJJiMzOTttIGd1ZXNzaW5nIHRoZXkgc2hvdWxkIHByb2JhYmx5IGJ5 IGluIHRoZSBpbmRleC4NPGJyPgoNPGJyPgpPbiAyMDE2LTExLTE1IDE1OjMwLCBIZW5yaWsgRWtl bmJlcmcgd3JvdGU6DTxicj4KJmd0OyBIZXJlIGFyZSB0aGUgaW5kZXhlcyBJIGhhdmUgZm9yIHRo b3NlIHF1ZXJpZXMNPGJyPgomZ3Q7IA08YnI+CiZndDsgSW5kZXhlczoNPGJyPgomZ3Q7IA08YnI+ CiZndDsgaGlzdF9hY2NvdW50X2JhbGFuY2XCoCA6OiAmcXVvdDtoaXN0X2FjY291bnRfYmFsYW5j ZV9peDEmcXVvdDsgYnRyZWUgKHRyYWRlX25vKQ08YnI+CiZndDsgDTxicj4KJmd0OyB0cmFkZXMg OjogJnF1b3Q7dHJhZGVzX3BrZXkmcXVvdDsgUFJJTUFSWSBLRVksIGJ0cmVlwqAgKHRyYWRlX25v KQ08YnI+CiZndDvCoCAmcXVvdDt0cmFkZXNfdHJhZGVfZGF0ZV9pbmRleCZxdW90OyBidHJlZSAo dHJhZGVfZGF0ZSkNPGJyPgomZ3Q7IA08YnI+CiZndDsgLy9IDTxicj4KJmd0OyANPGJyPgomZ3Q7 IFF1b3RpbmcgdmlubnkgJmx0OzxhIGhyZWY9Im1haWx0bzp2aW5ueUB4czRhbGwubmwiPnZpbm55 QHhzNGFsbC5ubDwvYT4mZ3Q7Og08YnI+CiZndDsgDTxicj4KJmd0OyZndDsgT24gMjAxNi0xMS0x NSAxNDoyNywgSGVucmlrIEVrZW5iZXJnIHdyb3RlOg08YnI+CiZndDsmZ3Q7IA08YnI+CiZndDsm Z3Q7Jmd0OyBIaSwNPGJyPgomZ3Q7Jmd0OyZndDsgDTxicj4KJmd0OyZndDsmZ3Q7IEkgaGF2ZSBz b21lIGRhdGEgdG8gam9pbiBhbmQgSSB3YW50IHRvIGdldCBzb20gYWR2aWNlIGZyb20geW91Lg08 YnI+CiZndDsmZ3Q7Jmd0OyANPGJyPgomZ3Q7Jmd0OyZndDsgQW55IHRpcHMgPyBBbnkgY29tbWVu dHMgYXJlIGFwcmVjaWF0ZWQNPGJyPgomZ3Q7Jmd0OyZndDsgDTxicj4KJmd0OyZndDsmZ3Q7IC8v SA08YnI+CiZndDsmZ3Q7Jmd0OyANPGJyPgomZ3Q7Jmd0OyZndDsgc2VsZWN0IHRyYWRlX25vDTxi cj4KJmd0OyZndDsmZ3Q7IGZyb20NPGJyPgomZ3Q7Jmd0OyZndDsgZm9yZWNhc3RfdHJhZGVzLmhp c3RfYWNjb3VudF9iYWxhbmNlDTxicj4KJmd0OyZndDsmZ3Q7IGxlZnQgam9pbiB0cmFkZXMgdXNp bmcgKHRyYWRlX25vKQ08YnI+CiZndDsmZ3Q7Jmd0OyB3aGVyZcKgIHRyYWRlX2RhdGUgJmd0OyBj dXJyZW50X2RhdGUgLSAxMjANPGJyPgomZ3Q7Jmd0OyZndDsgYW5kwqDCoMKgIHRyYWRlX2RhdGUg Jmx0OyBjdXJyZW50X2RhdGUgLSAzMA08YnI+CiZndDsmZ3Q7Jmd0OyBhbmTCoMKgwqAgZm9yZXgg PSAmIzM5O2YmIzM5Ow08YnI+CiZndDsmZ3Q7Jmd0OyBhbmTCoMKgwqAgb3B0aW9ucyA9ICYjMzk7 ZiYjMzk7DTxicj4KJmd0OyZndDsmZ3Q7IGdyb3VwIGJ5IHRyYWRlX25vDTxicj4KJmd0OyZndDsm Z3Q7IGhhdmluZyBtYXgoYWNjb3VudF9zaXplKSAmZ3Q7IDANPGJyPgomZ3Q7Jmd0OyZndDsgOw08 YnI+CiZndDsmZ3Q7Jmd0OyANPGJyPgomZ3Q7Jmd0OyZndDsgKCBRdWVyeSBQbGFuIDogPGEgaHJl Zj0iaHR0cHM6Ly9leHBsYWluLmRlcGVzei5jb20vcy80bE9EIj5odHRwczovL2V4cGxhaW4uZGVw ZXN6LmNvbS9zLzRsT0Q8L2E+ICkNPGJyPgomZ3Q7Jmd0OyZndDsgDTxicj4KJmd0OyZndDsmZ3Q7 IFFVRVJZIFBMQU4NPGJyPgomZ3Q7Jmd0OyZndDsgDTxicj4KJmd0OyZndDsmZ3Q7IA08YnI+CiZn dDsmZ3Q7IA08YnI+CiZndDsgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ08YnI+CiZndDsmZ3Q7Jmd0OyBIYXNoQWdncmVnYXRl wqAgKGNvc3Q9MzQ3NjA2MDUuNzYuLjM0NzczODY2LjI2IHJvd3M9MTA2MDg0MA08YnI+CiZndDsm Z3Q7Jmd0OyB3aWR0aD0xNSkNPGJyPgomZ3Q7Jmd0OyZndDsgKGFjdHVhbCB0aW1lPTExNDI4MTYu NjMyLi4xMTUwMTk0LjA3NiByb3dzPTI1NTA2MzQgbG9vcHM9MSkNPGJyPgomZ3Q7Jmd0OyZndDsg R3JvdXAgS2V5OiBoaXN0X2FjY291bnRfYmFsYW5jZS50cmFkZV9ubw08YnI+CiZndDsmZ3Q7Jmd0 OyBGaWx0ZXI6IChtYXgoaGlzdF9hY2NvdW50X2JhbGFuY2UuYWNjb3VudF9zaXplKSAmZ3Q7IDA6 Om51bWVyaWMpDTxicj4KJmd0OyZndDsmZ3Q7IFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDE4MjQw MDIzDTxicj4KJmd0OyZndDsmZ3Q7IC0mZ3Q7wqAgSGFzaCBKb2luwqAgKGNvc3Q9MzQwNzU4NS4z NS4uMzQ1MzA1MTIuMjkgcm93cz00NjAxODY5NA08YnI+CiZndDsmZ3Q7Jmd0OyB3aWR0aD0xNSkg KGFjdHVhbCB0aW1lPTYwMzIxLjIwMS4uMTEwODY0Ny4xNTEgcm93cz00NDE4ODk2Mw08YnI+CiZn dDsmZ3Q7Jmd0OyBsb29wcz0xKQ08YnI+CiZndDsmZ3Q7Jmd0OyBIYXNoIENvbmQ6IChoaXN0X2Fj Y291bnRfYmFsYW5jZS50cmFkZV9ubyA9DTxicj4KJmd0OyZndDsmZ3Q7IHRyYWRlcy50cmFkZV9u bykNPGJyPgomZ3Q7Jmd0OyZndDsgLSZndDvCoCBTZXEgU2NhbiBvbiBoaXN0X2FjY291bnRfYmFs YW5jZQ08YnI+CiZndDsmZ3Q7Jmd0OyAoY29zdD0wLjAwLi4xNDk4NjQ1NS4yMA08YnI+CiZndDsm Z3Q7Jmd0OyByb3dzPTU3MDA0NjcyMCB3aWR0aD0xNSkgKGFjdHVhbCB0aW1lPTAuMDE2Li41MjQ0 MjcuMTQwDTxicj4KJmd0OyZndDsmZ3Q7IHJvd3M9NTQ5MTY1NTk0DTxicj4KJmd0OyZndDsmZ3Q7 IGxvb3BzPTEpDTxicj4KJmd0OyZndDsmZ3Q7IC0mZ3Q7wqAgSGFzaMKgIChjb3N0PTMxNTkxODQu MTMuLjMxNTkxODQuMTMgcm93cz0xOTg3MjA5OA08YnI+CiZndDsmZ3Q7Jmd0OyB3aWR0aD0xMikg KGFjdHVhbCB0aW1lPTYwMzA3LjAwMS4uNjAzMDcuMDAxIHJvd3M9MjA3OTA2NTggbG9vcHM9MSkN PGJyPgomZ3Q7Jmd0OyZndDsgQnVja2V0czogMjA5NzE1MsKgIEJhdGNoZXM6IDHCoCBNZW1vcnkg VXNhZ2U6IDkxMzY1MWtCDTxicj4KJmd0OyZndDsmZ3Q7IC0mZ3Q7wqAgSW5kZXggU2NhbiB1c2lu ZyB0cmFkZXNfdHJhZGVfZGF0ZV9pbmRleCBvbg08YnI+CiZndDsmZ3Q7Jmd0OyB0cmFkZXMNPGJy PgomZ3Q7Jmd0OyZndDsgKGNvc3Q9MC41OC4uMzE1OTE4NC4xMyByb3dzPTE5ODcyMDk4IHdpZHRo PTEyKSAoYWN0dWFsDTxicj4KJmd0OyZndDsmZ3Q7IHRpbWU9MC4wNzguLjUyMjEzLjk3NiByb3dz PTIwNzkwNjU4IGxvb3BzPTEpDTxicj4KJmd0OyZndDsmZ3Q7IEluZGV4IENvbmQ6ICgodHJhZGVf ZGF0ZSAmZ3Q7DTxicj4KJmd0OyZndDsmZ3Q7ICgoJiMzOTtub3cmIzM5Ozo6Y3N0cmluZyk6OmRh dGUgLSAxMjApKSBBTkQgKHRyYWRlX2RhdGUgJmx0Ow08YnI+CiZndDsmZ3Q7Jmd0OyAoKCYjMzk7 bm93JiMzOTs6OmNzdHJpbmcpOjpkYXRlIC0gMzApKSkNPGJyPgomZ3Q7Jmd0OyZndDsgRmlsdGVy OiAoKE5PVCBmb3JleCkgQU5EIChOT1Qgb3B0aW9ucykpDTxicj4KJmd0OyZndDsmZ3Q7IFJvd3Mg UmVtb3ZlZCBieSBGaWx0ZXI6IDIzODc1MjMNPGJyPgomZ3Q7Jmd0OyZndDsgUGxhbm5pbmcgdGlt ZTogMi4xNTcgbXMNPGJyPgomZ3Q7Jmd0OyZndDsgRXhlY3V0aW9uIHRpbWU6IDExNTEyMzQuMjkw IG1zDTxicj4KJmd0OyZndDsmZ3Q7ICgxNSByb3dzKQ08YnI+CiZndDsmZ3Q7IFdoYXQga2luZCBv ZiBpbmRleGVzIGhhdmUgeW91IGNyZWF0ZWQgZm9yIHRob3NlIHRhYmxlcz8NPGJyPgomZ3Q7Jmd0 OyANPGJyPgomZ3Q7Jmd0OyAtLQ08YnI+CiZndDsmZ3Q7IFNlbnQgdmlhIHBnc3FsLXBlcmZvcm1h bmNlIG1haWxpbmcgbGlzdA08YnI+CiZndDsmZ3Q7ICg8YSBocmVmPSJtYWlsdG86cGdzcWwtcGVy Zm9ybWFuY2VAcG9zdGdyZXNxbC5vcmciPnBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3Jn PC9hPikNPGJyPgomZ3Q7Jmd0OyBUbyBtYWtlIGNoYW5nZXMgdG8geW91cg08YnI+CiZndDsmZ3Q7 IHN1YnNjcmlwdGlvbjo8YSBocmVmPSJodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVm L3Bnc3FsLXBlcmZvcm1hbmNlIj5odHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bn c3FsLXBlcmZvcm1hbmNlPC9hPg08YnI+Cg08YnI+Cg08YnI+Ci0tIA08YnI+ClNlbnQgdmlhIHBn c3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAoPGEgaHJlZj0ibWFpbHRvOnBnc3FsLXBlcmZv cm1hbmNlQHBvc3RncmVzcWwub3JnIj5wZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZzwv YT4pDTxicj4KVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOg08YnI+CjxhIGhy ZWY9Imh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFuY2Ui Pmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFuY2U8L2E+ DTxicj4KPC9wPgo8L2Jsb2NrcXVvdGU+PC9kaXY+