Re: High rate of transaction failure with the Serializable Isolation Level

From: Reza Taheri <rtaheri(at)vmware(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High rate of transaction failure with the Serializable Isolation Level
Date: 2014-07-25 23:24:02
Message-ID: 680fc8147cf34818bc06a972c6775ccc@EX13-MBX-013.vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

We are hoping the spec will get wrapped up in the next 6 months, but industry standard councils move very slowly! However, if there is interest in getting involved and helping, the TPC might be receptive to earlier access.

BTW, just to let folks know how large of an undertaking this has been, this is an estimate of the lines of code developed so far:

§ 700 lines of run-time shell scripts
§ 700 lines of build-time shell scripts
§ 3.5K lines of DDL and DML
§ 4K lines of C code to test the DML
§ 22K lines of C, C++, and Java code in the benchmark driver
§ 45K lines of C++ code in VGen

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-
> performance-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
> Sent: Friday, July 25, 2014 2:47 PM
> To: pgsql-performance(at)postgresql(dot)org
> Subject: Re: High rate of transaction failure with the Serializable Isolation
> Level
>
> On 07/23/2014 06:18 PM, Reza Taheri wrote:
> > [By way of introduction, we are a TPC subcommittee that is developing
> > a benchmark with cloud-like characteristics for virtualized databases.
> > The end-to-end benchmarking kit will be publicly available, and will
> > run on PGSQL]
>
> Awesome! Any idea when it will be available? Our community could really
> use some updated benchmark tooling ...
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> https://urldefense.proofpoint.com/v1/url?u=http://pgexperts.com/&k=oIv
> Rg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=b9TKmA0CPjroD2HLPTHU27nI9P
> Jr8wgKO2rU9QZyZZU%3D%0A&m=tao9MSozUNfqQO2rwn3fQPjQbSY7t6i7va
> Qnrs%2F%2B%2FWI%3D%0A&s=3cc04ce20eaf8319b9d2727420905b24ad64be
> b8d283142b321dde138026ed8d
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> https://urldefense.proofpoint.com/v1/url?u=http://www.postgresql.org/m
> ailpref/pgsql-
> performance&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=b9TKmA0CP
> jroD2HLPTHU27nI9PJr8wgKO2rU9QZyZZU%3D%0A&m=tao9MSozUNfqQO2r
> wn3fQPjQbSY7t6i7vaQnrs%2F%2B%2FWI%3D%0A&s=9c73db2dfd89fef26217
> f410046c8557b726bc8c5d0bf53053ea0e33294032f7

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jiří Nádvorník 2014-07-26 10:46:31 Cursor + upsert (astronomical data)
Previous Message Josh Berkus 2014-07-25 21:47:01 Re: High rate of transaction failure with the Serializable Isolation Level