Re: FOR KEY LOCK foreign keys - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: FOR KEY LOCK foreign keys
Date
Msg-id 4E240F82020000250003F450@gw.wicourts.gov
Whole thread Raw
In response to Re: FOR KEY LOCK foreign keys  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reduced power consumption in autovacuum launcher process
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Made ecpglib write double with a precision of 15 digits.