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

From Hiroshi Inoue
Subject RE: [HACKERS] Recovery on incomplete write
Date
Msg-id 001001bf0a4b$12b46360$2801007e@cadzone.tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] Recovery on incomplete write  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> -----Original Message-----
> From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
> Sent: Tuesday, September 28, 1999 11:54 PM
> To: Tom Lane
> Cc: Hiroshi Inoue; pgsql-hackers
> Subject: Re: [HACKERS] Recovery on incomplete write
>
>
> > "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.
>

Maybe it isn't so difficult to fix.
I would provide a patch.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp



pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: [HACKERS] DROP TABLE inside transaction block
Next
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] MS Access upsizing