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

From Simon Riggs
Subject Re: Preventing index scans for non-recoverable index AMs
Date
Msg-id 1229593227.4793.355.camel@ebony.2ndQuadrant
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, 2008-12-18 at 08:29 +0200, Heikki Linnakangas 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.

Agreed.

> I think we should just leave it alone for 8.4, and fix it properly in a 
> future relase by implementing WAL-logging for hash indexes.

You really think we should just leave it alone? That gives me less work,
so I will accept that if you think so. Gives me the shivers though.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Sync Rep: First Thoughts on Code
Next
From: Peter Eisentraut
Date:
Subject: Re: Variadic parameters vs parameter defaults