Skip site navigation (1) Skip section navigation (2)

Re: 8192 BLCKSZ ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8192 BLCKSZ ?
Date: 2000-11-28 21:24:34
Message-ID: 10411.975446674@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Nathan Myers <ncm(at)zembu(dot)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.

Of course, there's still no guarantee if you get a hardware failure
or sector write failure (recovery from the write failure might well
take longer than the drive has got).  But guarding against a plain
power-failure scenario is actually simpler than doing it the wrong
way.

But, as you say, customary page sizes are bigger than a sector, so
this is all moot for our purposes anyway :-(

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Nathan MyersDate: 2000-11-28 21:50:18
Subject: Re: 8192 BLCKSZ ?
Previous:From: Nathan MyersDate: 2000-11-28 21:01:34
Subject: Re: 8192 BLCKSZ ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group