Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE
Date
Msg-id 20060606203926.GA45331@pervasive.com
Whole thread Raw
In response to Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE  (Travis Cross <travis@crosswirecorp.com>)
List pgsql-hackers
On Tue, Jun 06, 2006 at 12:58:10PM -0400, Travis Cross wrote:
> >Do you *know* that the disk drive will not lie about write
> >complete?
> 
> "Know" is such a strong word ;)  Honestly, I have very little idea. 
>  I understand the nature of the problem this presents, as I've read 
> the very fine PostgreSQL manual many times over the years.
> 
> Because the drives I use are specifically designed to operate well 
> in a RAID environment, I would 'hope' that the drives perform honest 
> write operations.
> 
> I wonder if there is a utility to perform a deterministic test of 
> this...

Brad from livejournal.com wrote a utility that does just that, thought
it requires 2 machines to run the test.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work
Next
From: Tom Lane
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work