On Mon, Jun 16, 2014 at 9:47 PM, Peter Geoghegan <p...@heroku.com> wrote: > As discussed at the developer meeting at pgCon, I think that there is > a lot to be said for a tool that checks nbtree index invariants on > live systems.
Me too. > Attached prototype patch adds contrib extension, btreecheck. I don't feel qualified to comment on any of the substantive issues you raise, so instead I'd like to bikeshed the name. I suggest that we create one extension to be a repository for index-checking machinery (and perhaps also heap-checking machinery) and view this as the first of possibly several checkers to live there. Otherwise, we may eventually end up with separate extensions for btreecheck, hashcheck, gistcheck, gincheck, spgistcheck, minmaxcheck, vodkacheck, heapcheck, toastcheck, etc. which seems like excessive namespace pollution. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers