On Tue, Nov 18, 2014 at 2:01 PM, Peter Geoghegan <p...@heroku.com> wrote: > Do you intend to fix this up?
BTW, how do you feel about the B-Tree check extension [1]? It's very much related to pageinspect -- it's more or less a derivative. I don't think I'm going to have time (or that there is sufficient review bandwidth available) to get it into 9.5, but I should post a revision soon, so it's at least something that's available for use by an expert. I did some clean-up work on it that is unpublished. It'll become a more generic extension - "amcheck", per Robert's suggestion. One unpublished additional feature (that I have to fix a bug in) that isn't included in [1] is the idea of checking invariants across B-Tree pages. So, a scankey should indicate that the greatest (non-highkey) item on a non-rightmost page comports with the page that it has a right link to. Without race conditions. I don't have that swapped into my head at the moment, and so I don't have a good sense of how hard it'll be to fix the problem I found... [1] http://www.postgresql.org/message-id/cam3swzrtv+xmrwlwq6c-x7czvwavfdwfi4st1zz4ddgfh4y...@mail.gmail.com -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers