Re: could not read block 77 of relation 1663/16385/388818775

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: could not read block 77 of relation 1663/16385/388818775
Date: 2008-11-24 17:20:13
Message-ID: 492AE24D.7090107@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alexandra Nitzschke wrote:
> BTW... how about a block checksum that is checked just before writing
> a block and just after reading it? I know this would degrade
> performance, but I think we can afford that. Would it be possible to
> incorporate such code without having to do too much patching?

oracle has had an option for some time that uses read/only page
protection for each page of the shared buffer area... when oracle
knows it wants to modify a page, it un-protects it via a system
call. this catches any wild writes into the shared buffer area as a
memory protection fault.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Barry Reddy 2008-11-24 21:37:02 BUG #4548: Documentation Contradiction for 8.3
Previous Message Alexandra Nitzschke 2008-11-24 16:55:14 Re: could not read block 77 of relation 1663/16385/388818775