Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WZ2XZ-0005Uk-7U for pgsql-performance@arkaria.postgresql.org; Sat, 12 Apr 2014 18:20:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WZ2XY-0007mK-Lt for pgsql-performance@arkaria.postgresql.org; Sat, 12 Apr 2014 18:20:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXVxK-0001hl-SX for pgsql-performance@postgresql.org; Tue, 08 Apr 2014 13:20:50 +0000 Received: from mail.humaninference.com ([94.142.215.52] helo=EX01.humaninference.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXVxD-0007ry-Cx for pgsql-performance@postgresql.org; Tue, 08 Apr 2014 13:20:49 +0000 Received: from EX01.humaninference.com ([192.168.0.24]) by ex01 ([192.168.0.24]) with mapi id 14.01.0438.000; Tue, 8 Apr 2014 15:21:25 +0200 From: Hans Drexler To: "pgsql-performance@postgresql.org" Subject: Re: batch update query performance Thread-Topic: batch update query performance Thread-Index: Ac9TLXDFm03jGAoXSbGGTAAIs9Gn4A== Date: Tue, 8 Apr 2014 13:21:25 +0000 Message-ID: <1396963239.13361.27.camel@hans-think> Accept-Language: nl-NL, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.0.129] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -2.2 (--) 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 RGVhciBKZWZmLCBBbGJlIGFuZCBIZWlra2ksCgpMZXQgbWUgc3RhcnQgYnkg dGhhbmtpbmcgeW91IGZvciB5b3VyIHRpbWUuIEl0IGlzIHJlYWxseSBuaWNl IHRvIGhhdmUgYQpyZWFsIHN1cHBvcnRpdmUgY29tbXVuaXR5LiBUaGFuayB5 b3UuCgpBZnRlciByZWFkaW5nIHRoZSBhbnN3ZXJzLCB3ZSBkZWNpZGVkIHRv IGRvIGFuIGV4cGVyaW1lbnQgd2l0aCBhCmZpbGxmYWN0b3Igb2YgNDAlIGFu ZCBkcm9wcGluZyB0aGUgaW5kZXggb24gdGhlIGlzX2dyY18wMDIgZmllbGQg KGJ1dApyZXRhaW5pbmcgdGhlIG90aGVyIGluZGV4ZXMuKSBUaGUgZXhwZXJp bWVudCBzaG93ZWQgYSByZWR1Y3Rpb24gaW4KcnVuLXRpbWUgdG8gfjEyNSBz ZWNvbmRzLiBUaGF0IGlzIGFsbW9zdCAyNSB0aW1lcyBmYXN0ZXIgdGhhbiBp dCB3YXMuIFdlCmFyZSBub3cgZG9pbmcgbW9yZSB0ZXN0cyB0byB2ZXJpZnkg dGhpcyBmaXguIFdlIHdpbGwgc2VuZCBhIFNPTFZFRAptZXNzYWdlIHdoZW4g dGhlIGZpeCBpcyB2ZXJpZmllZCAodW5sZXNzIHlvdSBzdGF0ZSB0byBub3Qg Ym90aGVyLi4uKQoKV2UgdGhpbmsgd2UgdW5kZXJzdGFuZCB3aHkgdGhlIGlt cHJvdmVtZW50IHdvcmtzLiBMZXQgbWUgc3RhdGUgb3VyCnVuZGVyc3RhbmRp bmcgaGVyZS4gUGxlYXNlIGNvbW1lbnQgaWYgd2UgZ290IGl0IHdyb25nLgoK SW5kZXggZW50cmllcyBwb2ludCB0byByZWNvcmQgcGFnZXMuIEFuIHVwZGF0 ZSBvbiBhIHJvdyByZXN1bHRzIGluIGEgbmV3CnJvdyBpbnN0YW5jZS4gSWYg dGhlIG5ldyBpbnN0YW5jZSBjYW4gYmUgd3JpdHRlbiBpbiB0aGUgc2FtZSBw YWdlIGFzIHRoZQpvbGQgaW5zdGFuY2UsIHRoZW4gbm8gaW5kZXhlcyBuZWVk IHRvIGJlIHVwZGF0ZWQgYmVjYXVzZSB0aGUgaW5kZXggc3RpbGwKcG9pbnRz IHRvIHRoZSBjb3JyZWN0IHBhZ2UuIChVbmxlc3MgdGhlIHVwZGF0ZSBpdHNl bGYgbW9kaWZpZXMgYW4KaW5kZXhlZCB2YWx1ZSkuIEJ5IHNwZWNpZnlpbmcg YSBmaWxsZmFjdG9yIG9mIDQwJSwgdGhlcmUgd2lsbCBiZSByb29tCmZvciBh biB1cGRhdGVkIHZlcnNpb24gb2YgZWFjaCByb3cgaW4gdGhlIHBhZ2UuCldl IGFzc3VtZSAoc29ycnkpIHRoYXQgdmFjdXVtaW5nIHRoZSB0YWJsZSB3aWxs IHJlbGVhc2UgdGhlIHNwYWNlIG9mIHRoZQpvbGQgcm93cywgc28gdGhhdCB3 ZSBjYW4gYWdhaW4gZG8gYW4gdXBkYXRlIHF1ZXJ5IGFuZCByZXVzZSB0aGUg ZnJlZWQgdXAKc3BhY2UgaW4gdGhlIHBhZ2VzLgoKCkplZmYsIGFuc3dlcmlu ZyB5b3VyIHF1ZXN0aW9uOiBUaGUgdXBkYXRlIGlzIGRvbmUgYWZ0ZXIgZWFj aCBjeWNsZS4gSXQKd2lsbCBhY3R1YWxseSBhbHNvIHVwZGF0ZSByb3dzIHRo YXQgd2VyZSBhbHJlYWR5IHVwZGF0ZWQgYmVmb3JlLiBXZQpyZWFsaXplIHRo aXMgaXMgYWN0dWFsbHkgd2FzdGVmdWwuCgoKU28gd2UgbWlnaHQgY2hhbmdl Cgp1cGRhdGUgdDY3Y2RpX25sX2NtcF9kZXNjciBzZXQgaXNfZ3JjXzAwMj0n WScKCnRvCgp1cGRhdGUgdDY3Y2RpX25sX2NtcF9kZXNjciBzZXQgaXNfZ3Jj XzAwMj0nWScgd2hlcmUgaXNfZ3JjXzAwMiBpcyBudWxsCgpUaGlzIHdpbGwg YXZvaWQgY3JlYXRpbmcgbmV3IHJlY29yZHMgZm9yIHJlY29yZHMgdGhhdCB3 aGVyZSBhbHJlYWR5CmNoYW5nZWQgYmVmb3JlLiBUaGlzIG1pZ2h0IGdpdmUg dXMgYWRkaXRpb25hbCBzcGVlZCBpbXByb3ZlbWVudC4KCgpBbGJlLCBhbnN3 ZXJpbmcgeW91ciBxdWVzdGlvbjogWWVzLCB0aGUgdXBkYXRlIHdhcyBpbmRl ZWQgZmluaXNoZWQgaW4gfjMKbWludXRlcyB3aGVuIGFsbCBpbmRleGVzIHdl cmUgZHJvcHBlZC4gRmlmdGVlbiBpbmRleGVzIGlzIGluZGVlZCBhIGJpZwpu dW1iZXIuIFRoZXNlIGluZGV4ZXMgYXJlIGNvbmZpZ3VyZWQgYnkgY29uc3Vs dGFudHMgb24gYQpwcm9qZWN0LWJ5LXByb2plY3QgYmFzaXMuIFRoZXkgYXJl IG5vdCBoYXJkIGNvZGVkIGluIHRoZSBzb2Z0d2FyZS4gSQp3aWxsIGhvd2V2 ZXIgYWR2aWNlIHRoZSBjb25zdWx0YW50IHRvIGhhdmUgYSBjcml0aWNhbCBs b29rIGF0IHRoZSBiaWcKbnVtYmVyIG9mIGluZGV4ZXMgdXNlZCBpbiB0aGlz IGNhc2UuCgpIZWlra2ksIFRoYW5rIHlvdSBmb3IgdGhlIG5pZnR5IHRlY2hu aXF1ZXMuIEkgZXNwZWNpYWxseSBsaWtlIHRoZQpwb3NzaWJsZSBzb2x1dGlv biB3aXRoIHBhcnRpdGlvbmluZyB0aGUgdGFibGUgYW5kIHVzaW5nIGEgdmll dy4gV2UgZG9uJ3QKdGhpbmsgd2UgY2FuIGRvIHRoaXMgYXQgdGhpcyBwb2lu dC4gTGV0IG1lIGVsYWJvcmF0ZSBhIGJpdCB0byBleHBsYWluCndoeS4KClRo ZSBhcHBsaWNhdGlvbiB3b3JrcyBpbiBjeWNsZXMuIEVhY2ggY3ljbGVzIGFk ZHMgbW9yZSByZWNvcmRzIHRvIHRoZQp0YWJsZS4gTmV3IHJlY29yZHMgaGF2 ZSBhIE5VTEwgdmFsdWUgaW4gZmllbGQgaXNfZ3JjXzAwMi4gQXQgdGhlIGVu ZCBvZgp0aGUgY3ljbGUsIHRoZSB2YWx1ZSBvZiBhbGwgZXhpc3RpbmcgcmVj b3JkcyBpcyBjaGFuZ2VkIHRvICdZJy4gRHVyaW5nCnRoZSBjeWNsZSwgc29t ZSByZWNvcmRzIGhhdmUgaXNfZ3JjXzAwMiBOVUxMIGFuZCBvdGhlciBoYXZl IHZhbHVlICdZJy4KVGhpcyBpcyB1c2VkIGZvciB0aGUgcHJvY2Vzc2luZy4g QSB2aWV3IGNhbiBvbmx5IHdvcmsgaWYgYWxsIHJvd3MgaGF2ZSBhCnNpbmds ZSB2YWx1ZS4gV2UgY291bGQgdXNlIHR3byB0YWJsZXMgKG9uZSB3aXRoIHJl Y29yZHMgZnJvbSBvbGQgY3ljbGVzLApvbmUgd2l0aCByZWNvcmRzIGZyb20g dGhlIG5ldyBjeWNsZSkgYW5kIGEgdmlldy4gQnV0IHRoYXQgbWVhbnMgY29w eWluZwphbGwgcmVjb3JkcyBmcm9tIHRoZSAibmV3IiB0byB0aGUgIm9sZGVy IiB0YWJsZSBpbiBlYWNoIGN5Y2xlLgoKS2luZCByZWdhcmRzLAoKSGFucyBE cmV4bGVyCgoKCgoKLS0gClNlbnQgdmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1h aWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcp ClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDov L3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5j ZQo=