Re: Gist Recovery testing - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: Gist Recovery testing
Date
Msg-id 42B06EA0.40808@kaltenbrunner.cc
Whole thread Raw
In response to Re: Gist Recovery testing  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Gist Recovery testing
List pgsql-hackers
Teodor Sigaev wrote:
>> btree manages to avoid calling the index support functions during WAL
>> restore --- can't you do the same?  Perhaps you need to be including
>> more information in the initial xlog records, so that the cleanup step
>> has everything it needs.  Or resort to brute-force search (which is more
>> or less what btree does).  I don't think this operation needs to be very
>> efficient, since it's a corner case that should only seldom be invoked.
> 
> 
> I've just commited WALogging for GiST. It works for online backup 
> (normal recovery) and mostly after crash, but in this case it can't
> restore inclompleted  inserts although it can detected and say to log
> thet it's needed to reindex GiST index.


FYI: we now have at least 4 machines(otter,kingfisher,lionfish,corgi) on
the buildfarm crashing during testing of GIST-related things in contrib.

Any chance this could be related to this change ?


Stefan


pgsql-hackers by date:

Previous
From: "John Hansen"
Date:
Subject: Re: LGPL
Next
From: Josh Berkus
Date:
Subject: Re: max_fsm_pages >800k ... ?