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 49789B35.80804@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))  (Robert Haas <robertmhaas@gmail.com>)
Re: Pluggable Indexes (was Re: rmgr hooks (v2))  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
> On Thu, 2009-01-22 at 16:15 +0200, Heikki Linnakangas wrote:
>> That might be useful. But again, could just as well be implemented as an 
>> external tool like pglesslog.
> 
> There is no WAL record for "no-op", at least not one of variable length.

Hmm, maybe there should be? That seems like a useful thing to have for 
external tools.

> The WAL files can't just have chunks of zeroes in the middle of them,
> they must be CRC valid and chained together in the exact byte position.
> There isn't any way to do this, even if there were, that's a seriously
> complex way of doing that.

Hmm, I think you could remove the records in the middle, rechain the 
remaining ones, recalculate the crc, and put an xlog switch record at 
the end. I agree that's seriously complicated, a no-op record would be 
much simpler.

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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Pluggable Indexes (was Re: rmgr hooks (v2))
Next
From: Robert Haas
Date:
Subject: Re: Pluggable Indexes (was Re: rmgr hooks (v2))