Re: FOR KEY LOCK foreign keys

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <noah(at)2ndQuadrant(dot)com>,<alvherre(at)commandprompt(dot)com>
Cc: <dimitri(at)2ndquadrant(dot)fr>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FOR KEY LOCK foreign keys
Date: 2011-07-18 15:48:34
Message-ID: 4E240F82020000250003F450@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Noah Misch wrote:
>
>> With this patch in its final form, I have completed 180+ suite
>> runs without a failure.
>
> The attached patch allows the tests to pass when
> default_transaction_isolation is stricter than 'read committed'.

Without these two patches the tests fail about one time out of three
on my machine at the office at the 'read committed' transaction
isolation level, and all the time at stricter levels. On my machine
at home I haven't seen the failures at 'read committed'. I don't
know if this is Intel (at work) versus AMD (at home) or what.

With both Noah's patch and mine I haven't yet seen a failure in
either environment, with a few dozen tries..

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-07-18 16:16:50 Re: pgsql: Made ecpglib write double with a precision of 15 digits.
Previous Message Tom Lane 2011-07-18 15:32:39 Re: Reduced power consumption in autovacuum launcher process