Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsWb3-0006wy-Nz for pgsql-performance@arkaria.postgresql.org; Mon, 16 Dec 2013 11:44:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VsWb2-0004gI-W9 for pgsql-performance@arkaria.postgresql.org; Mon, 16 Dec 2013 11:44:25 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsWb2-0004gB-2E for pgsql-performance@postgresql.org; Mon, 16 Dec 2013 11:44:24 +0000 Received: from mrelay.celltick.com ([212.150.2.147]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsWax-0007uE-TW for pgsql-performance@postgresql.org; Mon, 16 Dec 2013 11:44:23 +0000 Received: from Cobra.celltick.com ([172.17.252.101]) by Cobra.celltick.com ([172.17.252.101]) with mapi id 14.03.0158.001; Mon, 16 Dec 2013 13:42:31 +0200 From: Yuri Levinsky To: "depesz@depesz.com" , "pgsql-performance@postgresql.org" CC: Craig James Subject: Re: Current query of the PL/pgsql procedure. Thread-Topic: [PERFORM] Current query of the PL/pgsql procedure. Thread-Index: Ac75sUKZGDxYuNp9SiyESE/JhRf7WAAhzwKAAAaShmA= Date: Mon, 16 Dec 2013 11:42:30 +0000 Message-ID: References: <20131216102619.GA27781@depesz.com> In-Reply-To: <20131216102619.GA27781@depesz.com> Accept-Language: he-IL, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.252.126] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -2.4 (--) 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 IERlYXIgRGVwZXN6LA0KVGhpcyBpcyB2ZXJ5IHByb2JsZW1hdGljIHNvbHV0 aW9uOiBJIGhhdmUgdG8gY2hhbmdlIHdob2xlISEhIG15IGNvZGUgdG8gcHV0 IGFwcHJvcHJpYXRlIGNvbW1lbnQgd2l0aCBxdWVyeSB0ZXh0IGJlZm9yZSBh bnkgcXVlcnkgZXhlY3V0aW9uLiBJbiBhZGRpdGlvbiBJIHdvdWxkIGxpa2Ug dG8ga25vdyBjdXJyZW50IGV4ZWN1dGlvbiBwbGFuLCB0aGF0IHNlZW1zIHRv IGJlIGltcG9zc2libGUuIFRoaXMgaXMgdmVyeSBoYXJkIGxpbWl0YXRpb24g bGV0J3Mgc2F5LiBJbiBjYXNlIG9mIHByb2R1Y3Rpb24gaXNzdWUgSSdsbCBq dXN0IHVuYWJsZSB0byBkbyBpdDogdGhlIGlzc3VlIGFscmVhZHkgaGFwcGVu aW5nLCBJIGNhbid0IHN0b3AgcHJvY2VkdXJlIGFuZCBzdGFydCBjb2RlIGNo YW5nZS4NCkphbWVzLA0KSSBzYXcgeW91ciByZXBseTogSSBzZWUgdGhlIGZ1 bmN0aW9uIGlzIHJ1bm5pbmcsIGl0J3MganVzdCBub3QgY2xlYXIgdGhhdCBl eGFjdGx5IGFuZCBob3cgdGhpcyBmdW5jdGlvbiBkb2luZy4gDQoNClNpbmNl cmVseSB5b3VycywNCg0KDQpZdXJpIExldmluc2t5LCBEQkENCkNlbGx0aWNr IFRlY2hub2xvZ2llcyBMdGQuLCAzMiBNYXNraXQgU3QuLCBIZXJ6bGl5YSA0 NjczMywgSXNyYWVsDQpNb2JpbGU6ICs5NzIgNTQgNjEwNzcwMywgT2ZmaWNl OiArOTcyIDkgOTcxMDIzOTsgRmF4OiArOTcyIDkgOTcxMDIyMg0KDQotLS0t LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogZGVwZXN6QGRlcGVzei5j b20gW21haWx0bzpkZXBlc3pAZGVwZXN6LmNvbV0gDQpTZW50OiBNb25kYXks IERlY2VtYmVyIDE2LCAyMDEzIDEyOjI2IFBNDQpUbzogWXVyaSBMZXZpbnNr eQ0KQ2M6IHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3JnDQpTdWJq ZWN0OiBSZTogW1BFUkZPUk1dIEN1cnJlbnQgcXVlcnkgb2YgdGhlIFBML3Bn c3FsIHByb2NlZHVyZS4NCg0KT24gU3VuLCBEZWMgMTUsIDIwMTMgYXQgMDQ6 MTg6MThQTSArMDAwMCwgWXVyaSBMZXZpbnNreSB3cm90ZToNCj4gRGVhciBB TEwsDQo+IEkgYW0gcnVubmluZyBQTC9wZ3NxbCBwcm9jZWR1cmUgd2l0aCBz cWwgc3RhdGVtZW50cyB0aGF0IHRha2luZyBhIGxvbmcgDQo+IHRpbWUuIEkg YWJsZSB0byBzZWUgdGhlbSBpbiB0aGUgbG9nIGp1c3QgYWZ0ZXIgdGhlaXIg Y29tcGxldGlvbi4gSG93IA0KPiBjYW4gSSBzZWUgY3VycmVudGx5IHJ1bm5p bmcgU1FMIHN0YXRlbWVudD8gIEkgYW0gYWJsZSB0byBzZWUgaW4gDQo+IHBn X3N0YXRfYWN0aXZpdHkgb25seSBteSBjYWxsIHRvIGZ1bmN0aW9uLiBNYW55 IHRoYW5rcyBpbiBhZHZhbmNlLg0KDQpwZ19zdGF0X2FjdGl2aXR5IGFuZCBw ZyBsb2dzLCBjYW4ndCBzZWUgd2hhdCB5b3VyIGZ1bmN0aW9uIGRvZXMgaW50 ZXJuYWxseS4NCg0KV2hhdCB5b3UgY2FuIGRvLCB0aG91Z2gsIGlzIHRvIGFk ZCBzb21lICJSQUlTRSBMT0ciIHRvIHRoZSBmdW5jdGlvbiwgc28gdGhhdCBp dCB3aWxsIGxvZyBpdHMgcHJvZ3Jlc3MuDQoNCkNoZWNrIHRoaXMgZm9yIGV4 YW1wbGU6DQpodHRwOi8vd3d3LmRlcGVzei5jb20vMjAxMC8wMy8xOC9wcm9m aWxpbmctc3RvcmVkLXByb2NlZHVyZXNmdW5jdGlvbnMvDQoNCkJlc3QgcmVn YXJkcywNCg0KZGVwZXN6DQoNCgotLSAKU2VudCB2aWEgcGdzcWwtcGVyZm9y bWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jl c3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9u OgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXBl cmZvcm1hbmNlCg==