On Nov 28, 2011, at 3:44 PM, Alvaro Herrera wrote: > I wonder if it would be worthwhile to build some sort of tool to scan > the heap and ensure that there are index entries for all heap items, > just to test the hypothesis. Not that this would enlighten on the > source of the actual problem.
There was a project to create a sanity-checker for Postgres databases... did that ever go anywhere? It seems like this would be a good addition for that tool, if it exists. In either case, I am all for better capabilities to detect data problems (I'm looking at you, block checksum project! ;) -- Jim C. Nasby, Database Architect j...@nasby.net 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers