From mboxrd@z Thu Jan 1 00:00:00 1970 From: Robert Haas Subject: Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation [and 2 more messages] Date: Wed, 14 Dec 2016 09:38:15 -0500 Message-ID: References: <1481307991-16971-1-git-send-email-ian.jackson@eu.citrix.com> <22606.47105.549023.301281@mariner.uk.xensource.com> <22607.56276.807567.924144@mariner.uk.xensource.com> <22608.6345.97849.783099@mariner.uk.xensource.com> <22608.14118.291149.821376@mariner.uk.xensource.com> Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Return-path: Received: from mail6.bemta3.messagelabs.com ([195.245.230.39]) by lists.xenproject.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cHAhJ-00036F-L2 for xen-devel@lists.xenproject.org; Wed, 14 Dec 2016 14:38:21 +0000 Received: by mail-qt0-f181.google.com with SMTP id p16so23831676qta.0 for ; Wed, 14 Dec 2016 06:38:20 -0800 (PST) In-Reply-To: List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xen.org Sender: "Xen-devel" To: Kevin Grittner Cc: xen-devel@lists.xenproject.org, Ian Jackson , Thomas Munro , "pgsql-hackers@postgresql.org" List-Id: xen-devel@lists.xenproject.org VGhhbmtzIGZvciB0aGUgcmVwbHkuCgpPbiBXZWQsIERlYyAxNCwgMjAxNiBhdCA5OjI2IEFNLCBL ZXZpbiBHcml0dG5lciA8a2dyaXR0bkBnbWFpbC5jb20+IHdyb3RlOgo+IGNvbnNpZGVyZWQuICBF c3NlbnRpYWxseSwgdGhlIHBvc2l0aW9uIElhbiBoYXMgYmVlbiB0YWtpbmcgaXMgdGhhdAo+IFBv c3RncmVTUUwgc2hvdWxkIHByb3ZpZGUgIHRoZSBndWFyYW50ZWUgb2YgKDIpIGFib3ZlLiAgQXMg ZmFyIGFzIEkKPiBjYW4gc2VlLCB0aGF0IHdvdWxkIHJlcXVpcmUgdXNpbmcgUzJQTCAtLSBzb21l dGhpbmcgdGhlIGNvbW11bml0eQo+IHJpcHBlZCBvdXQgb2YgUG9zdGdyZVNRTCBiZWNhdXNlIG9m IGl0cyBob3JyaWJsZSBwZXJmb3JtYW5jZSBhbmQKPiBoYXMgcmVmdXNlZCB0byBjb25zaWRlciBy ZXN0b3JpbmcgKGZvciBnb29kIHJlYXNvbiwgSU1PKS4KCkknbSBub3Qgc3VyZSBJYW4gaXMgaW50 ZW50aW9uYWxseSB0YWtpbmcgdGhhdCBwb3NpdGlvbi4gIE5vdCBhbGwgb2YgdXMKYXJlIGFzIGZh bWlsaWFyIHdpdGggdGhlIHJhbWlmaWNhdGlvbnMgb2YgZXZlcnkgc2VyaWFsaXphYmlsaXR5CmJl aGF2aW9yIHdlIG1heSB3YW50IGFzIHlvdSBhcmUuCgo+IEh1aCwgSSBoYWQgdG8gdGhpbmsgYWJv dXQgdGhhdCBmb3IgYSBtaW51dGUsIGJ1dCB5b3UgYXJlIHJpZ2h0Cj4gYWJvdXQgbmV2ZXIgcm9s bGluZyBiYWNrIGEgcmVhZC1vbmx5IHRyYW5zYWN0aW9uIGF0IGNvbW1pdCB0aW1lIC4uLgoKWWVh aCwgSSBoYWQgdG8gdGhpbmsgYWJvdXQgaXQgZm9yIGFib3V0IGFuIGhvdXIgLi4uIGFuZCBsb29r IGF0IHRoZQpjb2RlIGFuZCBSRUFETUUtU1NJLiAgU28gaWYgeW91IG9ubHkgaGFkIHRvIHRoaW5r IGFib3V0IGl0IGZvciBhCm1pbnV0ZSwgeW91IHdpbi4gOi0pCgo+PiBpZiBlaXRoZXIgdHJhbnNh Y3Rpb24gaGFkIGV4ZWN1dGVkIGJlZm9yZSB0aGUgb3RoZXIgaW4gYQo+PiBzZXJpYWwgc2NoZWR1 bGUsIHRoZSBzZWNvbmQgdHJhbnNhY3Rpb24gaW4gdGhlIHNjaGVkdWxlIHdvdWxkIGhhdmUgaGFk Cj4+IHRvIGhhdmUgc2VlbiAoQSwgQicpIG9yIChBJywgQikgcmF0aGVyIHRoYW4gKEEsIEIpLCBi dXQgdGhhdCdzIG5vdAo+PiB3aGF0IGhhcHBlbmVkLiAgQnV0IHdoYXQgaWYgZWFjaCBvZiBUMSBh bmQgVDIgZGlkIHRoZSByZWFkcyBpbiBhCj4+IHN1YnRyYW5zYWN0aW9uLCByb2xsZWQgaXQgYmFj aywgYW5kIHRoZW4gZGlkIHRoZSB3cml0ZSBpbiB0aGUgbWFpbgo+PiB0cmFuc2FjdGlvbiBhbmQg Y29tbWl0dGVkPyAgVGhlIGRhdGFiYXNlIHN5c3RlbSBoYXMgdHdvIG9wdGlvbnMuCj4+IEZpcnN0 LCBpdCBjb3VsZCBhc3N1bWUgdGhhdCB0aGUgdG9wbGV2ZWwgdHJhbnNhY3Rpb24gbWF5IGhhdmUg cmVsaWVkCj4+IG9uIHRoZSByZXN1bHRzIG9mIHRoZSBhYm9ydGVkIHN1YnRyYW5zYWN0aW9uLgo+ Cj4gVGhpcyBpcyB3aGF0IHdlIGRvIGluIG91ciBpbXBsZW1lbnRhdGlvbiBvZiBTU0kuICBQcmVk aWNhdGUgbG9ja3MKPiBmcm9tIHJlYWRzIHdpdGhpbiBzdWJ0cmFuc2FjdGlvbnMgYXJlIG5vdCBk aXNjYXJkZWQsIGV2ZW4gaWYgdGhlCj4gd29yayBvZiB0aGUgc3VidHJhbnNhY3Rpb24gaXMgb3Ro ZXJ3aXNlIGRpc2NhcmRlZC4KCk9oLCBpbnRlcmVzdGluZy4gIEp1c3QgdG8gYmUgY2xlYXIsIEkn bSBub3QgbG9iYnlpbmcgdG8gY2hhbmdlIHRoYXQ7IEkKd2FzIGd1ZXNzaW5nICh2ZXJ5IGxhdGUg YXQgbmlnaHQpIHdoYXQgZGVjaXNpb24geW91IHByb2JhYmx5IG1hZGUgYW5kCml0IHNlZW1zIEkg d2FzIGluY29ycmVjdC4gIEJ1dCBkb2Vzbid0IHRoYXQgaW1wbHkgdGhhdCBpZiBhIHJlYWQgZmFp bHMKaW4gYSBzdWJ0cmFuc2FjdGlvbiB3aXRoIHNlcmlhbGl6YXRpb25fZXJyb3IsIHRoZSBwYXJl bnQgTVVTVCBhbHNvIGJlCmtpbGxlZCB3aXRoIHNlcmlhbGl6YXRpb25fZXJyb3I/ICBJZiBub3Qs IHRoZW4gSSBkb24ndCBzZWUgaG93IHlvdSBjYW4KZXNjYXBlIGhhdmluZyByZXN1bHRzIHRoYXQs IG92ZXJhbGwsIGFyZSBub3Qgc2VyaWFsaXphYmxlLgoKPiBXaGF0IHdlIG1pc3NlZCBpcyB0aGF0 LCB3aGlsZSB3ZSB0b29rIGFjdGlvbiB0byB0cnkgdG8gZW5zdXJlIHRoYXQKPiBhIHNlcmlhbGl6 YXRpb24gZmFpbHVyZSBjb3VsZCBub3QgYmUgZGlzY2FyZGVkLCB3ZSBkaWRuJ3QgY29uc2lkZXIK PiB0aGF0IGEgY29uc3RyYWludCB2aW9sYXRpb24gZXhjZXB0aW9uIHdoaWNoIHdhcyBwcmV2ZW50 aW5nIGFuCj4gYW5vbWFseSAqY291bGQqIGJlIGRpc2NhcmRlZC4gIEVmZmVjdGl2ZWx5LCB0aGlz IGhhcyBlc2NhbGF0ZWQKPiBkZXRlY3Rpb24gb2Ygc2VyaWFsaXphdGlvbiBmYWlsdXJlcyBpbnZv bHZpbmcgcmVhZHMgd2hpY2ggYXJlIHBhcnQKPiBvZiBlbmZvcmNpbmcgZGVjbGFyYXRpdmUgY29u c3RyYWludHMgZnJvbSB0aGUgbGV2ZWwgb2YgYSBmZWF0dXJlCj4gcmVxdWVzdCB0byBjdXJlIGEg c2lnbmlmaWNhbnQgYW5ub3lhbmNlIGZvciB0aG9zZSB1c2luZyB0aGVtLCB0byBhCj4gYnVnIGZp eCBuZWNlc3NhcnkgdG8gcHJldmVudCBzZXJpYWxpemF0aW9uIGFub21hbGllcy4KCkhtbS4gIEkg c2VlLgoKPiBGb3J0dW5hdGVseSwgVGhvbWFzIE11bnJvIHRvb2sgYW4gaW50ZXJlc3QgaW4gdGhl IHByb2JsZW0gYXMgaXQKPiByZWxhdGVkIHRvIGR1cGxpY2F0ZXMgb24gcHJpbWFyeSBrZXlzLCB1 bmlxdWUgY29uc3RyYWludHMsIGFuZAo+IHVuaXF1ZSBpbmRleGVzLCBhbmQgcHV0IGZvcndhcmQg YSBwYXRjaCB0aGF0IGN1cmVkIHRoZSBkZWZlY3QgaW4KPiB0aGUgY29tbW9uIGNhc2VzLCBhbmQg cHJvdmlkZWQgYW4gZWFzeSB3b3JrYXJvdW5kIGZvciB0aGUgb25lIGNhc2UKPiBoZSB3YXMgdW5h YmxlIHRvIGZpeCBpbiB0aGF0IGluaXRpYWwgcGF0Y2guICBUbyBmaW5pc2ggdGhlIHdvcmsgZm9y Cj4gdGhlc2UgY29uc3RyYWludHMgYW5kIGluZGV4ZXMsIEkgdGhpbmsgd2UgbmVlZCB0byBhZGQg cHJlZGljYXRlCj4gbG9ja2luZyB3aGlsZSBkZXNjZW5kaW5nIHRvIHRoZSBpbnNlcnRpb24gcG9p bnQgIGR1cmluZyB0aGUgY2hlY2sKPiBmb3IgYW4gZXhpc3RpbmcgZHVwbGljYXRlLgoKSSBzdWdn ZXN0IGFkZGluZyBzb21ldGhpbmcgYWJvdXQgdGhpcyB0byBSRUFETUUtU1NJIGFzIGEga25vd24g aXNzdWUuCgo+IEknbSBub3Qgc3VyZSBhYm91dCBmb3JlaWduIGtleSBjb25zdHJhaW50cyBhbmQg ZXhjbHVzaW9uCj4gY29uc3RyYWludHMuICBJIGhhdmUgbmVpdGhlciBzZWVuIGEgZmFpbHVyZSBy ZWxhdGVkIHRvIGVpdGhlciBvZgo+IHRoZXNlLCBub3IgcHJvdmVuIHRoYXQgdGhlcmUgY2Fubm90 IGJlIG9uZS4gIFdpdGhvdXQgaGF2aW5nCj4gYXNzZXNzZWQgdGhlIHNjb3BlIG9mIHRoZSBwcm9i bGVtcyAoaWYgYW55KSBpbiB0aG9zZSBjb25zdHJhaW50cywKPiBpdCdzIGhhcmQgdG8gc2F5IHdo YXQgbmVlZHMgdG8gYmUgZG9uZSBvciBob3cgbXVjaCB3b3JrIGl0IGlzLgoKSSB0aGluayBpdCdz IGEgbmF0dXJhbCByZXN1bHQgb2YgaW1wbGVtZW50aW5nIHRlY2huaXF1ZXMgZnJvbSBhY2FkZW1p YwpyZXNlYXJjaCBwYXBlcnMgdGhhdCB0aGVyZSB3aWxsIHNvbWV0aW1lcyBiZSBvcGVuIHJlc2Vh cmNoIHF1ZXN0aW9ucy4KCi0tIApSb2JlcnQgSGFhcwpFbnRlcnByaXNlREI6IGh0dHA6Ly93d3cu ZW50ZXJwcmlzZWRiLmNvbQpUaGUgRW50ZXJwcmlzZSBQb3N0Z3JlU1FMIENvbXBhbnkKCl9fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fClhlbi1kZXZlbCBtYWls aW5nIGxpc3QKWGVuLWRldmVsQGxpc3RzLnhlbi5vcmcKaHR0cHM6Ly9saXN0cy54ZW4ub3JnL3hl bi1kZXZlbAo=