Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XAoqs-0007c5-Qa for pgsql-performance@arkaria.postgresql.org; Fri, 25 Jul 2014 23:24:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XAoqr-00054m-SF for pgsql-performance@arkaria.postgresql.org; Fri, 25 Jul 2014 23:24:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XAoqq-00054g-WB for pgsql-performance@postgresql.org; Fri, 25 Jul 2014 23:24:37 +0000 Received: from smtp-outbound-2.vmware.com ([208.91.2.13]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XAoqj-0006qB-CD for pgsql-performance@postgresql.org; Fri, 25 Jul 2014 23:24:34 +0000 Received: from sc9-mailhost3.vmware.com (sc9-mailhost3.vmware.com [10.113.161.73]) by smtp-outbound-2.vmware.com (Postfix) with ESMTP id 4249B283FD; Fri, 25 Jul 2014 16:24:22 -0700 (PDT) Received: from EX13-CAS-009.vmware.com (EX13-CAS-009.vmware.com [10.113.191.61]) by sc9-mailhost3.vmware.com (Postfix) with ESMTP id 3D63B412CC; Fri, 25 Jul 2014 16:24:22 -0700 (PDT) Received: from EX13-MBX-013.vmware.com (10.113.191.33) by EX13-MBX-012.vmware.com (10.113.191.32) with Microsoft SMTP Server (TLS) id 15.0.775.38; Fri, 25 Jul 2014 16:24:03 -0700 Received: from EX13-MBX-013.vmware.com ([fe80::b82b:d0bb:9cd7:392e]) by EX13-MBX-013.vmware.com ([fe80::b82b:d0bb:9cd7:392e%15]) with mapi id 15.00.0775.031; Fri, 25 Jul 2014 16:24:03 -0700 From: Reza Taheri To: Josh Berkus , "pgsql-performance@postgresql.org" Subject: Re: High rate of transaction failure with the Serializable Isolation Level Thread-Topic: High rate of transaction failure with the Serializable Isolation Level Thread-Index: Ac+m3REUfhN8/sxlQTylzpfYlwqkMQBdct0AAAMJXWA= Date: Fri, 25 Jul 2014 23:24:02 +0000 Message-ID: <680fc8147cf34818bc06a972c6775ccc@EX13-MBX-013.vmware.com> References: <53D2D055.3040909@agliodbs.com> In-Reply-To: <53D2D055.3040909@agliodbs.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.113.160.246] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -6.9 (------) 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 V2UgYXJlIGhvcGluZyB0aGUgc3BlYyB3aWxsIGdldCB3cmFwcGVkIHVwIGlu IHRoZSBuZXh0IDYgbW9udGhzLCBidXQgaW5kdXN0cnkgc3RhbmRhcmQgY291 bmNpbHMgbW92ZSB2ZXJ5IHNsb3dseSEgIEhvd2V2ZXIsIGlmIHRoZXJlIGlz IGludGVyZXN0IGluIGdldHRpbmcgaW52b2x2ZWQgYW5kIGhlbHBpbmcsIHRo ZSBUUEMgbWlnaHQgYmUgcmVjZXB0aXZlIHRvIGVhcmxpZXIgYWNjZXNzLg0K DQpCVFcsIGp1c3QgdG8gbGV0IGZvbGtzIGtub3cgaG93IGxhcmdlIG9mIGFu IHVuZGVydGFraW5nIHRoaXMgaGFzIGJlZW4sIHRoaXMgaXMgYW4gZXN0aW1h dGUgb2YgdGhlIGxpbmVzIG9mIGNvZGUgZGV2ZWxvcGVkIHNvIGZhcjoNCg0K wqcgIDcwMCBsaW5lcyBvZiBydW4tdGltZSBzaGVsbCBzY3JpcHRzDQrCpyAg NzAwIGxpbmVzIG9mIGJ1aWxkLXRpbWUgc2hlbGwgc2NyaXB0cw0KwqcgIDMu NUsgbGluZXMgb2YgRERMIGFuZCBETUwNCsKnICA0SyBsaW5lcyBvZiBDIGNv ZGUgdG8gdGVzdCB0aGUgRE1MDQrCpyAgMjJLIGxpbmVzIG9mIEMsIEMrKywg IGFuZCBKYXZhIGNvZGUgaW4gdGhlIGJlbmNobWFyayBkcml2ZXINCsKnICA0 NUsgbGluZXMgb2YgQysrIGNvZGUgaW4gVkdlbg0KDQo+IC0tLS0tT3JpZ2lu YWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IHBnc3FsLXBlcmZvcm1hbmNlLW93 bmVyQHBvc3RncmVzcWwub3JnIFttYWlsdG86cGdzcWwtDQo+IHBlcmZvcm1h bmNlLW93bmVyQHBvc3RncmVzcWwub3JnXSBPbiBCZWhhbGYgT2YgSm9zaCBC ZXJrdXMNCj4gU2VudDogRnJpZGF5LCBKdWx5IDI1LCAyMDE0IDI6NDcgUE0N Cj4gVG86IHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3JnDQo+IFN1 YmplY3Q6IFJlOiBIaWdoIHJhdGUgb2YgdHJhbnNhY3Rpb24gZmFpbHVyZSB3 aXRoIHRoZSBTZXJpYWxpemFibGUgSXNvbGF0aW9uDQo+IExldmVsDQo+IA0K PiBPbiAwNy8yMy8yMDE0IDA2OjE4IFBNLCBSZXphIFRhaGVyaSB3cm90ZToN Cj4gPiBbQnkgd2F5IG9mIGludHJvZHVjdGlvbiwgd2UgYXJlIGEgVFBDIHN1 YmNvbW1pdHRlZSB0aGF0IGlzIGRldmVsb3BpbmcNCj4gPiBhIGJlbmNobWFy ayB3aXRoIGNsb3VkLWxpa2UgY2hhcmFjdGVyaXN0aWNzIGZvciB2aXJ0dWFs aXplZCBkYXRhYmFzZXMuDQo+ID4gVGhlIGVuZC10by1lbmQgYmVuY2htYXJr aW5nIGtpdCB3aWxsIGJlIHB1YmxpY2x5IGF2YWlsYWJsZSwgYW5kIHdpbGwN Cj4gPiBydW4gb24gUEdTUUxdDQo+IA0KPiBBd2Vzb21lISAgQW55IGlkZWEg d2hlbiBpdCB3aWxsIGJlIGF2YWlsYWJsZT8gIE91ciBjb21tdW5pdHkgY291 bGQgcmVhbGx5DQo+IHVzZSBzb21lIHVwZGF0ZWQgYmVuY2htYXJrIHRvb2xp bmcgLi4uDQo+IA0KPiAtLQ0KPiBKb3NoIEJlcmt1cw0KPiBQb3N0Z3JlU1FM IEV4cGVydHMgSW5jLg0KPiBodHRwczovL3VybGRlZmVuc2UucHJvb2Zwb2lu dC5jb20vdjEvdXJsP3U9aHR0cDovL3BnZXhwZXJ0cy5jb20vJms9b0l2DQo+ IFJnMSUyQmRHQWdPb00xQklsTExxdyUzRCUzRCUwQSZyPWI5VEttQTBDUGpy b0QySExQVEhVMjduSTlQDQo+IEpyOHdnS08yclU5UVp5WlpVJTNEJTBBJm09 dGFvOU1Tb3pVTmZxUU8ycnduM2ZRUGpRYlNZN3Q2aTd2YQ0KPiBRbnJzJTJG JTJCJTJGV0klM0QlMEEmcz0zY2MwNGNlMjBlYWY4MzE5YjlkMjcyNzQyMDkw NWIyNGFkNjRiZQ0KPiBiOGQyODMxNDJiMzIxZGRlMTM4MDI2ZWQ4ZA0KPiAN Cj4gDQo+IC0tDQo+IFNlbnQgdmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1haWxp bmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcpDQo+ IFRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoNCj4gaHR0 cHM6Ly91cmxkZWZlbnNlLnByb29mcG9pbnQuY29tL3YxL3VybD91PWh0dHA6 Ly93d3cucG9zdGdyZXNxbC5vcmcvbQ0KPiBhaWxwcmVmL3Bnc3FsLQ0KPiBw ZXJmb3JtYW5jZSZrPW9JdlJnMSUyQmRHQWdPb00xQklsTExxdyUzRCUzRCUw QSZyPWI5VEttQTBDUA0KPiBqcm9EMkhMUFRIVTI3bkk5UEpyOHdnS08yclU5 UVp5WlpVJTNEJTBBJm09dGFvOU1Tb3pVTmZxUU8ycg0KPiB3bjNmUVBqUWJT WTd0Nmk3dmFRbnJzJTJGJTJCJTJGV0klM0QlMEEmcz05YzczZGIyZGZkODlm ZWYyNjIxNw0KPiBmNDEwMDQ2Yzg1NTdiNzI2YmM4YzVkMGJmNTMwNTNlYTBl MzMyOTQwMzJmNw0KCi0tIApTZW50IHZpYSBwZ3NxbC1wZXJmb3JtYW5jZSBt YWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3Jn KQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6 Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFu Y2UK