Re: Preventing index scans for non-recoverable index AMs - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Preventing index scans for non-recoverable index AMs
Date
Msg-id 2e78013d0812180418n37cf4f81l77c9b331cdc6465d@mail.gmail.com
Whole thread Raw
In response to Re: Preventing index scans for non-recoverable index AMs  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Preventing index scans for non-recoverable index AMs
List pgsql-hackers
On Thu, Dec 18, 2008 at 11:59 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:

>
> Right, this is certainly not a new problem. It's not even a new problem in
> the context of replication or hot standby, because we already have the
> problem with PITR and file-based log shipping.
>
> Also, it's not just a problem *during* the recovery. The index is just as
> corrupt after the recovery has finished.
>

Just curious, how do we handle the case of corrupted hash index today
? If we can detect that the index is corrupt because of bad page
headers etc, then its still OK; we can throw an error. But what if the
hash index is used after recovery and it returns wrong tuple(s) ?

Thanks,
Pavan

-- 
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Preventing index scans for non-recoverable index AMs
Next
From: Heikki Linnakangas
Date:
Subject: Re: Preventing index scans for non-recoverable index AMs