Re: Serializable snapshot isolation error logging

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Dan S <strd911(at)gmail(dot)com>, Dan Ports <drkp(at)csail(dot)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Serializable snapshot isolation error logging
Date: 2010-09-21 17:14:56
Message-ID: AANLkTi=KBL3MGhDaKd0vg+65pcqRRL5oX_A84Po1Rzce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 21, 2010 at 12:57 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> What is the likelyhood that there exists an update pattern that
>> always give the failure in the slow transaction ?
>
> I don't know how to quantify that.  I haven't seen it yet in
> testing, but many of my tests so far have been rather contrived.  We
> disparately need more testing of this patch with realistic
> workloads.

I'm really hoping that Tom or Heikki will have a chance to take a
serious look at this patch soon with a view to committing it. It
sounds like Kevin has done a great deal of testing on his own, but
we're not going to really get field experience with this until it's in
the tree. It would be nice to get this in well before feature freeze
so that we have a chance to see what shakes out while there's still
time to adjust it. Recall that Hot Standby was committed in December
and we were still adjusting the code in May. It would be much nicer
to commit in September and finish up adjusting the code in February.
It helps get the release out on schedule.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sushant Sinha 2010-09-21 17:17:25 Re: english parser in text search: support for multiple words in the same position
Previous Message Alvaro Herrera 2010-09-21 17:02:05 Re: What happened to the is_<type> family of functions proposal?