Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461