> > It's changed in 7.1 by WAL - btree doesn't lose tuples in split
> > ops anymore and in after crash restart you'll never see btree
> > tuples pointing to unexisted heap tuples (because of index tuples
> > inserted/logged after heap ones).
>
> The main thing is that I consider myself to be pretty ok with
> postgresql right now, but it's still a major amount of manual
> labor to _absolutely_ make sure no data has been lost and make
> sure that no more corruption exists that could get the server
> to die or go off into some inifinite loop. We really haven't
> had these problems for a long time but it's be really comforting
> to have something that pretty much made sure it wouldn't.
Just remembered from my prev observations in index area that
it's still possible to get infinite loop if root page was
splitted but new root was not created...
Vadim