Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE
Дата
Msg-id 20060606203926.GA45331@pervasive.com
обсуждение исходный текст
Ответ на Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE  (Travis Cross <travis@crosswirecorp.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: That EXPLAIN ANALYZE patch still needs work
Следующее
От: Tom Lane
Дата:
Сообщение: Re: That EXPLAIN ANALYZE patch still needs work