Re: 8192 BLCKSZ ?
От | mlw |
---|---|
Тема | Re: 8192 BLCKSZ ? |
Дата | |
Msg-id | 3A2503F8.95F21FB@mohawksoft.com обсуждение исходный текст |
Ответ на | Re: 8192 BLCKSZ ? (Matthew Kirkwood <matthew@hairy.beasts.org>) |
Список | pgsql-hackers |
Matthew Kirkwood wrote: > > On Tue, 28 Nov 2000, Tom Lane wrote: > > > Nathan Myers <ncm@zembu.com> writes: > > > In the event of a power outage, the drive will stop writing in > > > mid-sector. > > > > Really? Any competent drive firmware designer would've made sure that > > can't happen. The drive has to detect power loss well before it > > actually loses control of its actuators, because it's got to move the > > heads to the safe landing zone. If it checks for power loss and > > starts that shutdown process between sector writes, never in the > > middle of one, voila: atomic writes. > > In principle, that is correct. However, the SGI XFS people > have apparently found otherwise -- what can happen is that > the drive itself has enough power to complete a write, but > that the disk/controller buffers lose power and so you end > up writing a (perhaps partial) block of zeroes. I have worked on a few systems that intend to take a hard power failure gracefully. It is a very hard thing to do, with a lot of specialized circuitry. While it is nice to think about, on a normal computer systems one can not depend on a system shutting down gracefully on a hard power loss without a smart UPS and daemon to shut down the system. It does not matter one bit about disk write sizes or what ever. Unless the computer can know it is about to lose power, it can not halt its operations and enter a safe mode. The whole "pull the plug" mentality is silly. Unless a system hardware is specifically designed to manage this and proper software in place, it can not be done, and any "compliance" you think you see is simply luck. Any computer that has important data should have a smart UPS and a daemon to manage it. -- http://www.mohawksoft.com
В списке pgsql-hackers по дате отправления: