Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id AEB5BB5DBDD for ; Thu, 26 May 2011 01:01:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 27474-08 for ; Thu, 26 May 2011 04:01:51 +0000 (UTC) X-Greylist: delayed 00:05:47.165886 by SQLgrey-1.7.6 Received: from nm15.bullet.mail.sp2.yahoo.com (nm15.bullet.mail.sp2.yahoo.com [98.139.91.85]) by mail.postgresql.org (Postfix) with SMTP id A5BD0B5DBDA for ; Thu, 26 May 2011 01:01:50 -0300 (ADT) Received: from [98.139.91.67] by nm15.bullet.mail.sp2.yahoo.com with NNFMP; 26 May 2011 03:56:02 -0000 Received: from [208.71.42.194] by tm7.bullet.mail.sp2.yahoo.com with NNFMP; 26 May 2011 03:56:02 -0000 Received: from [127.0.0.1] by smtp205.mail.gq1.yahoo.com with NNFMP; 26 May 2011 03:56:02 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1306382162; bh=0aFyfsTThDd4Cz+fCgUbW6VutaJN3JR2Gxi5P0dyfK4=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Date:Subject:Message-ID:From:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding; b=HAlgT3ivECDPl4TjNFuFDDEmIT2GbY3XZiSkzWAX1PHR/P8YEssMu/erSIsMI4QDDSC9e8R1v6ioN2FVOxqBqpq8Okvd7t67hq6gAfoEmAqalSabTAtHh/jBCUgAVh3hITe6RQYxcoRbS5lUZHj6Zyq247Pelp3jiI74ksSbckE= X-Yahoo-Newman-Id: 505462.18457.bm@smtp205.mail.gq1.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: DR2mjLMVM1lEHZ48bUJq1lvCbQtIOkCvUScFvfOne_lfJ4o pPrqx4KdFLi9UCYtUxb06s4MZd8bx8lvLXy92.3NZh3imJc3kqATmcGF5ibA APguEaVkG2dlw_Gz_sWQtPV4h_6wehNuiyyxt8Sd2uaFlCI1KyvOl.BFCWiy qWSDUJlJXu0U_Zi1OBMp9nnVU5T4FT30qdDRo7vO2dCXeKo_6IXBxiywq8vU hDaALCMO_Q5yDLLbmgJZPGOrxF2pnMahJyl.c6imFndtKhKWVXNz6RJ.RpQF VtK2RdxhjccIl4dcz36H_uG1mQzgrlM58q6wJMYWBOJouyrmrsdKq0wrekoc 0qB1iA.4jONn1D3oh2H6KBjehR7JZzLGgxRrDYKHN X-Yahoo-SMTP: rF38uU2swBAU1_SlC0tV4FYHkzg- Received: from localhost (santhkn@208.54.5.145 with plain) by smtp205.mail.gq1.yahoo.com with SMTP; 25 May 2011 20:56:02 -0700 PDT Date: Wed, 25 May 2011 20:55:53 -0700 Subject: Re: Speeding up loops in pl/pgsql function Message-ID: <726kdq53i20ndcnrt61io437.1306382146325@email.android.com> From: Santhakumaran To: Steve Crawford , "Reuven M. Lerner" Cc: Alex Hunsaker , pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.907 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01, UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 201105/359 X-Sequence-Number: 43868 RGtsb3NreGUKClN0ZXZlIENyYXdmb3JkIDxzY3Jhd2ZvcmRAcGlucG9pbnRyZXNlYXJjaC5jb20+ IHdyb3RlOgoKPk9uIDA1LzI1LzIwMTEgMTE6NDUgQU0sIFJldXZlbiBNLiBMZXJuZXIgd3JvdGU6 Cj4+IEhpLCBBbGV4LiAgWW91IHdyb3RlOgo+Pj4gSGF2ZSB5b3UgdHJpZWQgc29tZXRoaW5nIGxp a2U6Cj4+PiBTRUxFQ1QgIGVuY29kZShyZWdleHBfcmVwbGFjZSgnMTQxMTQyMTQzJywgJyhcZHsz fSknLCAnXFxcMScsCj4+PiAnZycpOjpieXRlYSwgJ2VzY2FwZScpOwo+PiBIbW0sIGZvcmdvdCBh Ym91dCByZWdleHBfcmVwbGFjZS4gIEl0IG1pZ2h0IGRvIHRoZSB0cmljaywgYnV0IHdpdGhvdXQg Cj4+IGEgZnVsbC1ibG93biBldmFsIHRoYXQgSSBjYW4gcnVuIG9uIHRoZSByZXBsYWNlbWVudCBz aWRlLCBpdCdsbCBiZSBhIAo+PiBiaXQgbW9yZSBjaGFsbGVuZ2luZy4gIEJ1dCB0aGF0J3MgYSBn b29kIGRpcmVjdGlvbiB0byBjb25zaWRlciwgZm9yIHN1cmUuCj4KPlRoZSBmdW5jdGlvbiBnaXZl biBkaWRuJ3Qgd29yayBleGFjdGx5IGFzIHdyaXR0ZW4gZm9yIG1lIGJ1dCBpdCBpcyBvbiAKPnRo ZSByaWdodCB0cmFjay4gU2VlIGlmIHRoaXMgd29ya3MgZm9yIHlvdSAoaW5wdXQgdmFsaWRhdGlv biBpcyBsZWZ0IGFzIAo+YW4gZXhlcmNpc2UgZm9yIHRoZSByZWFkZXIuLi46KSk6Cj4KPmNyZWF0 ZSBvciByZXBsYWNlIGZ1bmN0aW9uIG9jdGFsX3N0cmluZ190b190ZXh0KHNvbWVvY3RhbCB0ZXh0 KSByZXR1cm5zIAo+dGV4dCBhcyAkJAo+ZGVjbGFyZQo+ICAgICBiaW5zdHJpbmcgdGV4dDsKPmJl Z2luCj4gICAgIGV4ZWN1dGUgJ3NlbGVjdCBFJycnIHx8IHJlZ2V4cF9yZXBsYWNlKCQxLCBFJyhc XGR7M30pJywgRSdcXFxcXFwxJywgCj4nZycpIHx8ICcnJycgaW50byBiaW5zdHJpbmc7Cj5yZXR1 cm4gYmluc3RyaW5nOwo+ZW5kCj4kJCBsYW5ndWFnZSBwbHBnc3FsOwo+Cj5DaGVlcnMsCj5TdGV2 ZQo+Cj4KPi0tIAo+U2VudCB2aWEgcGdzcWwtcGVyZm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3Nx bC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZykKPlRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1 YnNjcmlwdGlvbjoKPmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVy Zm9ybWFuY2UK