Re: B-tree parent pointer and checkpoints - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: B-tree parent pointer and checkpoints
Date
Msg-id 4D7A06F1.8050108@enterprisedb.com
Whole thread Raw
In response to Re: B-tree parent pointer and checkpoints  (Bruce Momjian <bruce@momjian.us>)
Responses Re: B-tree parent pointer and checkpoints
List pgsql-hackers
On 10.03.2011 22:50, Bruce Momjian wrote:
> Bruce Momjian wrote:
>>
>> Has this been addressed?
>
> I see we have with this commit:
>
>     9de3aa65f01fb51cbc725e8508ea233e4e92c46c

We fixed GiST. B-tree still has the issue that if you have a checkpoint 
in the middle of an insert, and crash, you might be left with a leaf 
node without a downlink in the parent.

That's relatively harmless, index searches and insertions work without 
the downlink. However, there's code in page deletion that ERRORs if the 
parent can't be found. That should be fixed.

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


pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: Fwd: index corruption in PG 8.3.13
Next
From: Gianni Ciolli
Date:
Subject: maximum digits for NUMERIC