IDE and write cache - Mailing list pgsql-admin

From Mark Lubratt
Subject IDE and write cache
Date
Msg-id 7FADF594-5C59-11D8-9292-000A9579AF50@indeq.com
Whole thread Raw
Responses Re: IDE and write cache  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: IDE and write cache  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Interesting discussions on IDE drives and their write caches.

I have a question...

You mentioned that you'd see the problem during a large number of
concurrent transactions.  My question is, is this a necessary condition
for the database crashing when the plug was pulled, or did you need use
a large number of concurrent transactions to "guarantee" that when you
pulled the plug, that it would be at an inopportune time?  In other
words, is an IDE drive still "more" susceptible to a power outage
problem even under light load?

Thanks!
Mark


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Log query results?
Next
From: kdyke@keycomputerconsultants.com
Date:
Subject: Re: book for postgresql