AW: [HACKERS] beta testing version

From: ZeugswetterA(at)Wien(dot)Spardat(dot)at (Zeugswetter Andreas SB)
To: news-list(dot)pgsql(dot)general(at)innominate(dot)de
Subject: AW: [HACKERS] beta testing version
Date: 2000-12-06 12:17:49
Message-ID: 11C1E6749A55D411A9670001FA68796336816B@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


> > > Sounds great! We can follow this way: when first after last
> > > checkpoint update to a page being logged, XLOG code can log
> > > not AM specific update record but entire page (creating backup
> > > "physical log"). During after crash recovery such pages will
> > > be redone first, ensuring page consistency for further redo ops.
> > > This means bigger log, of course.
> >
> > Be sure to include a CRC of each part of the block that you hope
> > to replay individually.
>
> Why should we do this? I'm not going to replay parts individually,
> I'm going to write entire pages to OS cache and than apply changes to
> them. Recovery is considered as succeeded after server is ensured
> that all applyed changes are on the disk. In the case of crash during
> recovery we'll replay entire game.

Yes, but there would need to be a way to verify the last page or record from txlog when
running on crap hardware. The point was, that crap hardware writes our 8k pages
in any order (e.g. 512 bytes from the end, then 512 bytes from front ...), and does not
even notice, that it only wrote part of one such 512 byte block when reading it back
after a crash. But, I actually doubt that this is true for all but the most crappy hardware.

Andreas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2000-12-06 12:58:20 Re: Overhead of tables.
Previous Message "Edmar Wiggers" 2000-12-06 11:58:39 RE: [HACKERS] Indexing for geographic objects?

Browse pgsql-hackers by date

  From Date Subject
Next Message Felix Lungu 2000-12-06 13:06:31 BLOB Help!
Previous Message "Edmar Wiggers" 2000-12-06 11:58:39 RE: [HACKERS] Indexing for geographic objects?