Re: Pluggable Indexes (was Re: rmgr hooks (v2)) - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Pluggable Indexes (was Re: rmgr hooks (v2))
Date
Msg-id 49787F6A.1060102@enterprisedb.com
Whole thread Raw
In response to Re: Pluggable Indexes (was Re: rmgr hooks (v2))  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Pluggable Indexes (was Re: rmgr hooks (v2))  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Pluggable Indexes (was Re: rmgr hooks (v2))  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Simon Riggs wrote:
> Immediate use cases for me would be
> 
> * ability to filter WAL records based on database or relation

This patch isn't enough to allow the catalog lookups. Without the 
catalog lookups, you might as well implement that as an external tool, 
like pglesslog.

> * ability to recover quickly from various types of bug, for example if
> new freespace code caused a corruption we would be able to sidestep it
> and get the database up again quickly without doing resetxlog and losing
> data.

That might be useful. But again, could just as well be implemented as an 
external tool like pglesslog.

(the new FSM implementation isn't WAL-logged, so that particular 
scenario isn't very plausible)

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Pluggable Indexes (was Re: rmgr hooks (v2))
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: deductive databases in postgreSQL