Re: [HACKERS] Recovery on incomplete write - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Recovery on incomplete write
Date
Msg-id 199909281454.KAA18708@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Recovery on incomplete write  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: [HACKERS] Recovery on incomplete write  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > I have wondered that md.c handles incomplete block(page)s
> > correctly.
> > Am I mistaken ?
> 
> I think you are right, and there may be some other trouble spots in that
> file too.  I remember thinking that the code depended heavily on never
> having a partial block at the end of the file.
> 
> But is it worth fixing?  The only way I can see for the file length
> to become funny is if we run out of disk space part way through writing
> a page, which seems unlikely...
> 

That is how he got started, the TODO item about running out of disk
space causing corrupted databases.  I think it needs a fix, if we can.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Recovery on incomplete write
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Operator definitions