Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DE9D8B5DBE0 for ; Tue, 24 May 2011 23:01:18 -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 09064-01 for ; Wed, 25 May 2011 02:01:11 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm18-vm3.bullet.mail.ne1.yahoo.com (nm18-vm3.bullet.mail.ne1.yahoo.com [98.138.91.148]) by mail.postgresql.org (Postfix) with SMTP id C77AEB5DC44 for ; Tue, 24 May 2011 23:01:10 -0300 (ADT) Received: from [98.138.90.48] by nm18.bullet.mail.ne1.yahoo.com with NNFMP; 25 May 2011 02:01:09 -0000 Received: from [98.138.226.132] by tm1.bullet.mail.ne1.yahoo.com with NNFMP; 25 May 2011 02:01:09 -0000 Received: from [127.0.0.1] by smtp219.mail.ne1.yahoo.com with NNFMP; 25 May 2011 02:01:09 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1306288869; bh=MPxEhLnbBNnmpCO87VRyK1CMm0pddRf/1UifXrdCt4c=; h=X-Yahoo-Newman-Id:Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Date:Subject:Message-ID:From:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=M2N7NfU8axonhI0INho99t+lLEAb2iJcWndBQDiRJhZ1mOMwvQY0a4n8AoToGVelZy1+LPGrCxF+jxIywncMpxPlYkL/aFgksbvhxugLaw6nc0zdc5vSwTd5LZelzRLc4HfpOqX24MKIpFOAxAlUDlJEsOtwwe4fqXLILd7s4yY= X-Yahoo-Newman-Id: 463735.23471.bm@smtp219.mail.ne1.yahoo.com Received: from localhost (santhkn@208.54.5.253 with plain) by smtp219.mail.ne1.yahoo.com with SMTP; 24 May 2011 19:01:08 -0700 PDT X-Yahoo-SMTP: rF38uU2swBAU1_SlC0tV4FYHkzg- X-YMail-OSG: mM_Wk9cVM1kFtRBVQibLCI3vVYUHOpJYJ91Pgcu.aUCxAxZ dLTmp86Nz8D5saoElRMZ8TTKLVHfKOXpIYkOp91vo6JRSGdwviCJDc2mTXQu ToW0XuUqajqDUVzJC6UElZNtWNWecjnSNUUFNRwMl74t08x8wqVRz4I28Agu 7H17ZfVAjXUiLXhmmx.Or.v9FIJIZ_bHkp3Owix87JFRB0I7rz2hnqARdiHS u1sNp.OluYCi2yoHw_9Qxh5AP1hMGfv.YxxSwVwgIEklyq.Sh356B2CjeBBL k.bnBvu.3zkCXLe.fHwnWACPUJk85GEXFbekyHal1mViaUL.YkQDSRttX2GR DZKvoQwHP5w2lTe7Z3m_40UFgr0rHjcEMmw-- X-Yahoo-Newman-Property: ymail-3 Date: Tue, 24 May 2011 19:01:06 -0700 Subject: Re: Performance degradation of inserts when database size grows Message-ID: From: Santhakumaran To: Tomas Vondra , 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/331 X-Sequence-Number: 43840 CgpUb21hcyBWb25kcmEgPHR2QGZ1enp5LmN6PiB3cm90ZToKCj5EbmUgMjQuNS4yMDExIDA3OjI0 LCBUZXJyeSBTY2htaXR0IG5hcHNhbChhKToKPj4gQXMgbmVhciBhcyBJIGNhbiB0ZWxsIGZyb20g eW91ciB0ZXN0IGNvbmZpZ3VyYXRpb24gZGVzY3JpcHRpb24sIHlvdSBoYXZlCj4+IEpNZXRlciAt LT4gSjJFRSAtLT4gUG9zdGdyZXMuCj4+IEhhdmUgeW91IHJ1bGVkIG91dCB0aGUgSjJFRSBzZXJ2 ZXIgYXMgdGhlIHByb2JsZW0/IFRoaXMgcHJvYmxlbSBtYXkgbm90Cj4+IGJlIHRoZSBkYXRhYmFz ZS4KPj4gSSB3b3VsZCB0YWtlIGEgbG9vayBhdCB5b3VyIGFwcCBzZXJ2ZXIncyBoZWFsdGggYW5k IGxvb2sgZm9yIGFueQo+PiBwb3RlbnRpYWwgaXNzdWVzIHRoZXJlIGJlZm9yZSBzcGVuZGluZyB0 b28gbXVjaCB0aW1lIG9uIHRoZSBkYXRhYmFzZS4KPj4gUGVyaGFwcyB0aGVyZSBhcmUgbWVtb3J5 IGlzc3VlcyBvciBleGNlc3NpdmUgZ2FyYmFnZSBjb2xsZWN0aW9uIG9uIHRoZQo+PiBhcHAgc2Vy dmVyPwo+Cj5JdCBtaWdodCBiZSBwYXJ0IG9mIHRoZSBwcm9ibGVtLCB5ZXMsIGJ1dCBpdCdzIGp1 c3QgYSBndWVzcy4gV2UgbmVlZCB0bwo+c2Ugc29tZSBpb3N0YXQgLyBpb3RvcCAvIHZtc3RhdCBv dXRwdXQgdG8gY29uZmlybSB0aGF0Lgo+Cj5UaGUgcHJvYmFibGUgY2F1c2UgaGVyZSBpcyB0aGF0 IHRoZSBpbmRleGVzIGdyb3cgd2l0aCB0aGUgdGFibGUsIGdldAo+ZGVlcGVyLCBzbyB3aGVuIHlv dSBpbnNlcnQgYSBuZXcgcm93IHlvdSBuZWVkIHRvIG1vZGlmeSBtb3JlIGFuZCBtb3JlCj5wYWdl cy4gVGhhdCdzIHdoeSB0aGUgbnVtYmVyIG9mIGJ1ZmZlcnMgZ3Jvd3Mgb3ZlciB0aW1lIGFuZCB0 aGUKPmNoZWNrcG9pbnQgdGFrZXMgbW9yZSBhbmQgbW9yZSB0aW1lICh0aGUgYXZlcmFnZSB3cml0 ZSBzcGVlZCBpcyBhYm91dCAxNQo+TUIvcyAtIG5vdCBzdXJlIGlmIHRoYXQncyBnb29kIG9yIGJh ZCBwZXJmb3JtYW5jZSkuCj4KPlRoZSBxdWVzdGlvbiBpcyB3aGV0aGVyIHRoaXMgaXMgaW5mbHVl bmNlZCBieSBvdGhlciBhY3Rpdml0eSAoSmF2YSBHQyBvcgo+c29tZXRoaW5nKQo+Cj5JIHNlZSB0 aHJlZSB3YXlzIHRvIGltcHJvdmUgdGhlIGNoZWNrcG9pbnQgcGVyZm9ybWFuY2U6Cj4KPiAgMSkg c2V0IGNoZWNrcG9pbnRfY29tcGxldGlvbl90YXJnZXQgPSAwLjkgb3Igc29tZXRoaW5nIGxpa2Ug dGhhdAo+ICAgICAodGhpcyBzaG91bGQgc3ByZWFkIHRoZSBjaGVja3BvaW50LCBidXQgaXQgYWxz byBpbmNyZWFzZXMgdGhlCj4gICAgIGFtb3VudCBvZiBjaGVja3BvaW50IHNlZ21lbnRzIHRvIGtl ZXApCj4KPiAgMikgbWFrZSB0aGUgYmFja2dyb3VuZCB3cml0ZXIgbW9yZSBhZ2dyZXNzaXZlICh0 dW5lIHRoZSBiZ3dyaXRlcl8qCj4gICAgIHZhcmlhYmxlcyksIHRoaXMgaXMgc2ltaWxhciB0byAo MSkKPgo+ICAzKSBpbXByb3ZlIHRoZSB3cml0ZSBwZXJmb3JtYW5jZSAobm90IHN1cmUgaG93IHJh bmRvbSB0aGUgSS9PIGlzIGluCj4gICAgIHRoaXMgY2FzZSwgYnV0IGEgZGVjZW50IGNvbnRyb2xs ZXIgd2l0aCBhIGNhY2hlIG1pZ2h0IGhlbHApCj4KPmFuZCB0aGVuIHR3byB3YXlzIHRvIGRlY3Jl YXNlIHRoZSBpbmRleCBvdmVyaGVhZCAvIGFtb3VudCBvZiBtb2RpZmllZAo+YnVmZmVycwo+Cj4g IDEpIGtlZXAgb25seSB0aGUgcmVhbGx5IG5lY2Vzc2FyeSBpbmRleGVzIChyZW1vdmUgZHVwbGlj YXRlLCBpbmRleGVzLAo+ICAgICByZW1vdmUgaW5kZXhlcyB3aGVyZSBhbm90aGVyIGluZGV4IGFs cmVhZHkgcGVyZm9ybXMgcmVhc29uYWJseSwKPiAgICAgZXRjLikKPgo+ICAyKSBwYXJ0aXRpb24g dGhlIHRhYmxlIChzbyB0aGF0IG9ubHkgaW5kZXhlcyBvbiB0aGUgY3VycmVudCBwYXJ0aXRpb24K PiAgICAgd2lsbCBiZSBtb2RpZmllZCwgYW5kIHRob3NlIHdpbGwgYmUgbW9yZSBzaGFsbG93KQo+ Cj5Ub21hcwo+Cj4tLSAKPlNlbnQgdmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAo cGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcpCj5UbyBtYWtlIGNoYW5nZXMgdG8geW91 ciBzdWJzY3JpcHRpb246Cj5odHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3Fs LXBlcmZvcm1hbmNlCg==