Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XUhj0-0001UP-23 for pgsql-performance@arkaria.postgresql.org; Thu, 18 Sep 2014 19:50:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XUhiz-0001WS-Ir for pgsql-performance@arkaria.postgresql.org; Thu, 18 Sep 2014 19:50:41 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XUhiy-0001WM-Nd for pgsql-performance@postgresql.org; Thu, 18 Sep 2014 19:50:40 +0000 Received: from smtp-o-3.desy.de ([2001:638:700:1038::1:9c]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XUhiv-0004HB-Rf for pgsql-performance@postgresql.org; Thu, 18 Sep 2014 19:50:38 +0000 Received: from smtp-map-3.desy.de (smtp-map-3.desy.de [131.169.56.68]) by smtp-o-3.desy.de (DESY-O-3) with ESMTP id B93852807E1 for ; Thu, 18 Sep 2014 21:50:35 +0200 (CEST) Received: from ZITSWEEP4.win.desy.de (zitsweep4.win.desy.de [131.169.97.98]) by smtp-map-3.desy.de (DESY_MAP_3) with ESMTP id A5ADE110E for ; Thu, 18 Sep 2014 21:50:35 +0200 (MEST) Received: from smtp-intra-3.desy.de (lb-40-26.desy.de) by ZITSWEEP4.win.desy.de (Clearswift SMTPRS 5.5.0) with ESMTP id ; Thu, 18 Sep 2014 21:50:35 +0200 Received: from z-mta-3.desy.de (z-mta-3.desy.de [131.169.55.137]) by smtp-intra-3.desy.de (DESY-INTRA-3) with ESMTP id 825171101; Thu, 18 Sep 2014 21:50:35 +0200 (MEST) Received: from z-mta-3.desy.de (localhost [127.0.0.1]) by z-mta-3.desy.de (Postfix) with ESMTP id 7C799400C0; Thu, 18 Sep 2014 21:50:35 +0200 (CEST) Received: from z-mta-3.desy.de (localhost [127.0.0.1]) by z-mta-3.desy.de (Postfix) with ESMTP id 69301400C4; Thu, 18 Sep 2014 21:50:35 +0200 (CEST) Received: from z-mbx-2.desy.de (z-mbx-2.desy.de [131.169.55.140]) by z-mta-3.desy.de (Postfix) with ESMTP id 5BDAB400C0; Thu, 18 Sep 2014 21:50:35 +0200 (CEST) Date: Thu, 18 Sep 2014 21:50:35 +0200 (CEST) Subject: Re: postgres 9.3 vs. 9.4 From: "Mkrtchyan, Tigran" To: Andrew Dunstan Cc: pgsql-performance@postgresql.org, Josh Berkus MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Message-ID: <1364297042.45601.1411069835217.JavaMail.zimbra@z-mbx-2.desy.de> X-Mailer: Zimbra 8.0.7_GA_6021 (MobileSync - Android/4.4.4-EAS-2.0) Thread-Topic: postgres 9.3 vs. 9.4 Thread-Index: jkCG08FunCeNIi6oA+W25yuZOw9pOg== X-Pg-Spam-Score: -1.6 (-) 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 Ck9uIFNlcCAxOCwgMjAxNCA5OjMyIFBNLCBBbmRyZXcgRHVuc3RhbiA8YW5k cmV3QGR1bnNsYW5lLm5ldD4gd3JvdGU6Cj4KPgo+IE9uIDA5LzE4LzIwMTQg MDM6MDkgUE0sIE1rcnRjaHlhbiwgVGlncmFuIHdyb3RlOiAKPiA+IAo+ID4g LS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLSAKPiA+PiBGcm9tOiAiSm9z aCBCZXJrdXMiIDxqb3NoQGFnbGlvZGJzLmNvbT4gCj4gPj4gVG86IHBnc3Fs LXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3JnIAo+ID4+IFNlbnQ6IFRodXJz ZGF5LCBTZXB0ZW1iZXIgMTgsIDIwMTQgNzo1NDoyNCBQTSAKPiA+PiBTdWJq ZWN0OiBSZTogW1BFUkZPUk1dIHBvc3RncmVzIDkuMyB2cy4gOS40IAo+ID4+ IAo+ID4+IE9uIDA5LzE4LzIwMTQgMDg6MDkgQU0sIE1rcnRjaHlhbiwgVGln cmFuIHdyb3RlOiAKPiA+Pj4+PiA5LjRiZXRhMjogCj4gPj4+Pj4gLi4uIAo+ ID4+Pj4+IAo+ID4+Pj4+Pj7CoMKgwqDCoMKgwqDCoMKgwqAgMC45NTc4NTTC oMKgwqDCoMKgwqDCoCBFTkQ7IAo+ID4+Pj4+Pj4gCj4gPj4+Pj4gTG9va3Mg bGlrZSBJTy4gCj4gPj4+IFBvc3RncmVzIGludGVybmFsIElPPyBNYXkgYmUu IFdlIGdldCA2MDBNQi9zIG9uIHRoaXMgU1NEcy4gCj4gPj4gV2hpbGUgaXQn cyBwb3NzaWJsZSB0aGF0IHRoaXMgaXMgYSBQb3N0Z3JlcyBpc3N1ZSwgbXkg Zmlyc3QgdGhvdWdodCBpcyAKPiA+PiB0aGF0IHRoZSB0d28gU1NEcyBhcmUg bm90IGFjdHVhbGx5IGlkZW50aWNhbC7CoCBUaGUgOS40IG9uZSBtYXkgZWl0 aGVyIAo+ID4+IGhhdmUgYSBmYXVsdCwgb3IgbWF5IGJlIG1vc3RseSBmdWxs IGFuZCBoZWF2aWx5IGZyYWdtZW50ZWQuwqAgT3IgdGhlIERlbGwgCj4gPj4g UENJZSBjYXJkIG1heSBoYXZlIGFuIGlzc3VlLiAKPiA+IAo+ID4gV2UgaGF2 ZSB0ZXN0ZWQgYm90aCBTU0RzIGFuZCB0aGV5IGhhdmUgaWRlbnRpY2FsIElP IGNoYXJhY3RlcmlzdGljcyBhbmQgCj4gPiBhcyBJIGFscmVhZHkgbWVudGlv bmVkLCBib3RoIGRhdGFiYXNlcyBhcmUgZnJlc2gsIGluY2x1ZGluZyBmaWxl c3lzdGVtLiAKPiA+IAo+ID4+IFlvdSBhcmUgdXNpbmcgInNjYWxlIDEiIHdo aWNoIGlzIGEgPCAxTUIgZGF0YWJhc2UsIGFuZCBvbmUgY2xpZW50IGFuZCAx IAo+ID4+IHRocmVhZCwgd2hpY2ggaXMgYW4gaW50ZXJlc3RpbmcgdGVzdCBJ IHdvdWxkbid0IG5lY2Vzc2FyaWx5IGhhdmUgZG9uZSAKPiA+PiBteXNlbGYu wqAgSSdsbCB0aHJvdyB0aGUgc2FtZSB0ZXN0IG9uIG9uZSBvZiBteSBtYWNo aW5lcyBhbmQgc2VlIGhvdyBpdCBkb2VzLiAKPiA+IHRoaXMgc2NlbmFyaW8g Y29ycmVzcG9uZHMgdG8gb3VyIHVzZSBjYXNlLiBXZSBuZWVkIGEgaGlnaCB0 cmFuc2FjdGlvbiByYXRlIAo+ID4gcGVyIGZvciBhIHNpbmdsZSBjbGllbnQu IEN1cnJlbnRseSBJIGNhbiBnZXQgb25seSB+MTUwMCB0cHMuIFVuZm9ydHVu YXRlbHksIAo+ID4gcG9zZ3RyZXNzIGRvZXMgbm90IHRlbGwgbWUgd2hlcmUg dGhlIGJvdHRsZW5lY2sgaXMuIElzIHRoaXMgaXMgZGVmZW5zaXZlbHkgCj4g PiBub3QgdGhlIGRpc2sgSU8uIAo+ID4gCj4gPiAKPiA+IAo+Cj4KPiBUaGlz IGlzIHdoZW4geW91IGRpZyBvdXQgdG9vbHMgbGlrZSBwZXJmLCBtYXliZS4K CkRvIHlvdSBoYXZlIGEgYmV0dGVyIHN1Z2dlc3Rpb25zID8KCj4KPiBjaGVl cnMgCj4KPiBhbmRyZXcgCgotLSAKU2VudCB2aWEgcGdzcWwtcGVyZm9ybWFu Y2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3Fs Lm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpo dHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXBlcmZv cm1hbmNlCg==